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
Tag: Time Intelligence Power BI
Now we are going to dive into the CALCULATE function in Power BI. We have already used the function many times but this is where I want to discuss it in detail. Getting The Sales Last Year With CALCULATE The CALCULATE function allows you to change the context of a calculation within a measure wherein
I’m going to show you how to calculate workdays between two dates either with the holidays counted or without the holidays. This is a topic that’s been asked over and over again on the Enterprise DNA Forum. I also believe that this will be a great way to close this Time Intelligence series, knowing that
I’m going to show you how to use the offset function in Power BI. It’s one of the most dynamic tools you can use especially in your date tables. Once you master how to apply it in your time intelligence projects, you can get more in-depth insights that you won’t get using any other approach.
I’ll show you how to set up dynamic start and end dates when you’re using power query date tables. If you’ve been following this series on different Time Intelligence subjects, you already know how to create a date table using power query functions. You might have also read about how to change the end date