VIDEO: Why and When Merge Queries in Power Query

VIDEO: Append Multiple Excel Files From One Folder

When a new month report comes out, many still use a manual method by copying and pasting the new month data into one big Excel master file. To speed up the process and reduce manual errors and typos, Power BI’s query editor comes as an effective solution.

BI May Help Companies During Post-COVID Recession

BI May Help Companies During Post-COVID Recession

When the world emerges out of the pandemic, businesses will have to embrace changes in how they operate, get rid of some of the least effective practices and focus more on business intelligence (BI) and analytics to stay afloat.

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

Cloud Brings Advanced Analytics to Everyone

Cloud Brings Advanced Analytics to Everyone

In the past, companies had to spend thousands of dollars just to make sure they can start using advanced analytics that required strong hardware requirements and computing power. In the recent years, the democratization of the cloud increased the adoption of advanced analytics across different industries.

Using CALCULATE in DAX (Intermediate)

Using CALCULATE in DAX (Intermediate)

When using CALCULATE it’s all about making sure that correct filters are applied. With CALCULATE you can override the existing filter context with the new ones inside the function. Watch our short tutorial below.