Tag: Time Intelligence

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

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

Creating Multi Threaded Dynamic Visuals – Advanced Power BI Technique

In this post, I want to show you what is without a doubt one of the most compelling visualisation techniques in Power BI. Never feel you are confined to use just the general visualisation options inside of Power BI (or custom visuals for that matter). You have a significant opportunity to make your visuals even

Continue reading

Dynamically Compare And Calculate Difference Between This Year & Last Year In Power BI Using DAX

If you want to start creating compelling reports with strong insights into information over time, then you’ve got to know how to use all the variations of time intelligence functions. Some are easy, but others are much more advanced and can be difficult to use. In this post though, I want to take you back

Continue reading