Tag: CALCULATE DAX

Budget Allocation: Monthly Forecasts Across Daily Results In Power BI

In this tutorial, I’ll go through a budget allocation technique in Power BI where you allocate Budgets at a monthly level versus Sales or Transaction Data at a daily level. You may watch the full video of this tutorial at the bottom of this blog. This scenario is very common when working with any type

Continue reading

Showing The Last Three Customer Sales Using The TOPN Function

I’m going to cover some great functions here in Power BI that are very useful across a variety of analytic scenarios. Some of these functions can help us work out the last three customer sales. You may watch the full video of this tutorial at the bottom of this blog. What I want to show

Continue reading

Data Normalization in Power BI for Different Days Results

Normalizing Results On Different Days - Time Related Analysis In Power BI Using DAX

This tutorial stems from another question on the Enterprise DNA Forum about data normalization. The techniques that I will teach you will be important in getting rid of anomalies that can possibly make things complicated during the data analysis. You may watch the full video of this tutorial at the bottom of this blog. Occasionally,

Continue reading