Tag: Time Comparison

Common Time Intelligence Patterns Used In Power BI

Common Time Intelligence Patterns Used In Power BI

I want to do a quick run through of time intelligence patterns commonly used in Power BI. This is covered in detail in the Mastering DAX Calculations course at Enterprise DNA online. In the course, there are in-depth discussions on how to use these functions and get better insights using time-related data. But for now,

Continue reading

Showcase QoQ Sales Using Time Intelligence In Power BI

In this tutorial, we’re going to cover how to calculate quarter on quarter sales differences using time intelligence in Power BI. We’re not just going to do it at a granular level- we are going to try and analyze trends based on quarter on quarter sales. Sometimes when you are looking at something from a

Continue reading

Compare Multiple Metrics Cumulatively In Power BI Using Advanced DAX

I’ve previously showcased how you can compare your actual results versus your budgeted results using advanced DAX. But, what if you also wanted to overlay some time comparison information so you’re comparing your actuals versus budget versus last year? Or perhaps versus last quarter? Or against any other time period you may want to select?

Continue reading

Compare Cumulative Information Over Different Months In Power BI

Showcasing cumulative results in Power BI 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

Continue reading