Tag: Analytical Scenarios

Measure Averages Per Day Using AVERAGEX With DAX

Measure Averages Per Day Using AVERAGEX With DAX

Here I’m going to show you how to use the function AVERAGEX with DAX in Power BI. By learning and understanding how to use this function, you very quickly open up a range of analysis that can be incredibly insightful and valuable. Maybe you want to work out the average sales you make per day,

Continue reading

Explore Forecasting Logic In Your Power BI Models Using DAX

Explore Forecasting Logic In Your Power BI Models Using DAX

It doesn’t get more real world than the video below for an application of Power BI to provide great insight. In the example I run though here, I want to compare my actual results to my forecasted results. Not only that – I want to view these cumulatively. The cumulative totals give me a much

Continue reading