Tag: CALCULATE DAX

A New Look At CALCULATE – Power BI

A New Look At CALCULATE – Power BI

In this tutorial, we’ll be looking at how to use the DAX function CALCULATE in Power BI. You can watch the full video of this tutorial at the bottom of this blog. CALCULATE is one of the most dynamic functions that can help you add deeper insights to your reports. But to truly understand it,

Continue reading

Time Intelligence DAX Functions In Power BI

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

Continue reading

Using Calculate Function Inside Power BI

Using Calculate Function Inside Power BI

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

Continue reading

Budgeting Performance Segmentation Using DAX In Power BI

Budgeting performance analysis might sometimes require us to segment the results we currently have to different groups. This is to analyze which performers were better than others versus their targets. You may watch the full video of this tutorial at the bottom of this blog. Power BI can manage performance segmentation, and understand their differences

Continue reading

How To Showcase Top Result In A Power BI Card Visualization

This tutorial came out as a question in the Enterprise DNA Support Forum where a member needed to work out the top value for a particular result, and wanted to show it in a Power BI card visualization. Moreover, the member wanted it to be dynamic so that the card visualization will change or update

Continue reading