In this tutorial, you’ll learn how to make a customer dashboard more intuitive using time intelligence in Power BI. This is the second step when creating a customer deep dive dashboard. When creating visualizations, you’ll most likely have to compare different time periods. This could be a comparison between the cumulative sales for two simultaneous years. So, you need to start writing more complex
For this tutorial, we’ll branch out to some examples of time intelligence calculations using a combination of DAX functions. This kind of calculation is useful when you want to compare your business data over a certain period. You can do it by days, months, quarters, or years. Aside from the CALCULATE function, using other DAX
In this tutorial, we’ll go through date harvesting in Power BI to get information from a date slicer for a time intelligence analysis. From previous tutorials, we’ve learned how to extend our date table while integrating a holiday table to it. Now, we need to harvest dates from the data slicer to start using our
I want to share with you a Power BI DAX formula technique to show growth performance effectively. In this tutorial, I’m going to demonstrate how it’s done, but there are so many different scenarios where you want to represent growth and this is just one example. The technique that I’m going to go through can
Latest post out on the Power BI blog out now! Comparing totals this year to last year is a pattern you will use many times over with Power BI. It is always a good benchmark when looking to analyse how a certain metric is performing in the business. Click here to jump over to the
