Tag: How to Use Aggregation Functions

Understanding Power BI Aggregations

Now, let’s delve deeper into one of the most important concepts in Power BI calculations — the aggregations. Power BI aggregations are formulas used to calculate a single summarized value from multiple rows that are grouped together. There are different ways to create aggregations in Power BI. Some of the examples of aggregation functions are

Continue reading

Common Time Intelligence Patterns Used In Power BI

Common Time Intelligence Patterns Used In Power BI

I want to do a quick run through of time intelligence patterns commonly used in Power BI. This is covered in detail in the Mastering DAX Calculations course at Enterprise DNA online. In the course, there are in-depth discussions on how to use these functions and get better insights using time-related data. But for now,

Continue reading

The Difference Between SUM vs SUMX In Power BI

SUM vs SUMX What's The Real Difference Between These DAX Measures

There is still a lot of confusion about the difference between SUM vs SUMX in Power BI. This is key knowledge that users have to master because both functions can be used across different scenarios, but there are cases where one is more efficient than the other. I’m going to focus on one example here

Continue reading

Dynamically compare current totals to last years totals

Latest post out on the Power BI blog out now! Comparing totals this year to last year is a pattern you will use many times over with Power BI. It is always a good benchmark when looking to analyse how a certain metric is performing in the business. Click here to jump over to the

Continue reading