Tag: DAX

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

Latest FREE Workshop Announcement – Effective Power BI Reporting

The last Enterprise DNA Learning Summit was a really great event, so I’ve decided to run another free encore workshop. During this next session – Effective Power BI Reporting – I’ll be running through many of my best practice techniques around building valuable Power BI solutions. Now this doesn’t just mean creating a good model,

Continue reading

Develop Advanced Scenario Analysis Models Using DAX in Power BI

I really wanted to showcase here how incredible Power BI is as an analytical tool. You can achieve so much that you might never have thought possible. Developing scenario analysis logic within Power BI models is probably my favorite technique to use, mainly because it can be so valuable to the business. Rather than just

Continue reading