Category: 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

Cumulatively Compare Information Over Different Months

Showcasing your results cumulatively is such a powerful way to visualize your data over time, especially if you are trying to show the difference in performance from one time period to another. When you try to present this at a daily or even monthly level, identifying the trend isn’t always so obvious. When you place

Continue reading

Four Pillars Of All High-Quality Power BI Solutions – Steps To Mastering Power BI & DAX

Create high quality Power BI solutions Power BI is a great suite of tools that enables business users, or anyone for that matter, to create advanced analysis on nearly any type or structure of data. But what does it really take to build high quality, what I like to call, scalable solutions with Power BI?

Continue reading

Forecasting Analysis Techniques in Power BI with DAX

Forecasting analysis in Power BI can be completed in quite an effective manner if you utilise the time intelligence functions in DAX effectively. In this example I wanted to run through the many options you have available to start automatically creating forecasts based on historical information. Your forecasts in a lot of cases will be

Continue reading

How to Measure Averages per Day in Power BI with DAX

Here I dive into the AVERAGEX function. 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, per month, per customer, per day, and so on. There

Continue reading