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 to where to start.
It’s important to get a really good base understanding of how these functions work, especially how they work with the CALCULATE function. Combining these two types of function is where the real power comes from.
It’s very common to want to compare data or your results over two time frames, so I want to show you how to do exactly that. Within this video I run through how to use SAMEPERIODLASTYEAR (yes it’s really that intuitive) to compare results from this year to those of last year.
I also run through how you can branch out into more advanced calculations once you’ve completed these first steps.
The insights are practically limitless – you can calculate things like the difference between this year and last year, the percentage change from last year, the best and worst performers… the list goes on. You can start finding valuable insights very quickly that historically are very difficult to achieve with tools like Excel. You certainly could do it, but your formulas would have been far, far more complex than within Power BI.
Check out this detailed video to learn all you need to know to do this yourself in your own models.