For this tutorial, we’ll branch out to some examples of time intelligence calculations using a combination of DAX functions. This kind of calculation is useful when you want to compare your business data over a certain period. You can do it by days, months, quarters, or years. Aside from the CALCULATE function, using other DAX
For this tutorial, I’ll cover how the CALCULATE function works and why it’s so crucial in Power BI. I’ll also show you some examples of its application. You can easily branch out to time intelligence calculations by using the CALCULATE function. Once you apply this technique, you’ll be able to produce high quality insights inside
In this blog post, I’ll introduce you to DAX table functions. Table functions are simply DAX functions that return a table. Some of the most common table functions that you can encounter in Power BI are the FILTER, VALUES, and ALL functions. Using these table functions, you can create virtual tables inside Power BI. Physical
This tutorial will teach you about different iterating functions and how to efficiently use them in your calculations. I often discuss how calculated columns are not required when making some calculations. This is because of iterators. Iterators or iterating functions can help you do a calculation without physically putting the results in the table. This
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
