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. You may watch the full video of this tutorial at the bottom of this blog. This is covered in detail in the Mastering DAX Calculations course at Enterprise DNA online. In the course, there are in-depth discussions on

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. You may watch the full video of this tutorial at the bottom of this blog. We’re not just going to do it at a granular level- we are going to try and analyze trends

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. You may watch the full video of this tutorial at the bottom of this blog. When you try to present this

Continue reading