Dynamically Compare And Calculate Difference Between This Year & Last Year In Power BI Using DAX

No comments

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.

***** Learning Power BI? *****
All Enterprise DNA TV Resources
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – Power BI Resources


***Learn more about Enterprise DNA Membership***membership banner 3

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s