Calculate Difference This Year vs Last Year in Power BI with DAX

Learn how to use DAX measures to work out the difference between calculated amounts this year versus last year. Get an intro into the concept of measure branching in DAX.

***** Video Details *****
0:24 - summing up revenue column
0:37 - total sales measure
1:46 - reviewing total sales information by date
2:34 - total sales last year
4:20 - difference between sales this year vs last year
5:42 - visualization of difference between sales this year vs last year

***** Learning Power BI? *****

***** Related Links*****

***** Related Course Modules*****

***** Related Support Forum Posts*****

[EnterpriseDNA]

Related

Related Course

Related Support Forum

[nancmadi]

I absolutely LOVE your videos, they are so clear and very understood. A great monotone and easy to listen to and follow along so nicely. THANK YOU for another wrinkle in my brain.

[curiouspie]

Thanks so much for your M Power Query and Dax time intelligence series. This is great. 🙌

[romasejal]

I have calculated same period last yr as per ur video but when i am selecting the year for which i want to make chart the same measure shows blank result. Why the same is happening? Pls guide

Great. Except for you lost me with the calendars at the end. Do you happen to have a link that would help me to know what those date calendars have to look like ?

[jazzista]

Great video and excellent explanation. Thanks

[mrgreenteatime]

Good formula, however what about Totals? This current method would not calculate totals correctly

[Hemantshyontry]

Hi Sam,
My sincere greetings. It's been a pleasure watching your videos. The way you teaches is simply astonishing. I need a small help from you, I am trying to create a measure wherein I would like to find top 10 performers in a heirarchy of Various year are on slicer. I am able to create the measure for top 10 performers for the above mentioned heirarchy independently but not able to do so in a single visual with drill mode on. Can you please help??

[marshal]

If the calendar table was created only for a monthly basis, say the end day of each month, how do you calculate monthly sales of leap year? Sameperiodlastyear function won't work for Feb of leap year right?

[yeasinarafatredoy]

Hi, Thanks for Your Lesson. But if i want to get the LMTD ( last month to date ) Vs MTD ( Month TO date) Data. How i will get the data.

[davehussey]

Hi Sam, How do I get the totals column on a matrix to calculate YTD. I have a matrix and the Variance calculates to the end of the month last year. Any ideas how to overcome this?

[Amaankhan-mgxi]

how to deal with the error "expects a contiguous selection when the date column" with the function when there are more then one variables are involved.

[james_msuk]

How would you do this if trying to compare 2019 to 2023?

[RichArd-eeqj]

Your an excellent teacher! Voice control. Organized thoughts. You don't go 'ahhh' (which is what I often do when I speak). You rock!

[Magmatic]

Can someone please help me understand why sometimes I see people adding a date table that automatically generates dates ranging from min and max date in the data and then link this table to the data model? Thanks.

[AmeyInamdar]

Thanks for the Video! (Heads up- it will work only when you've got contiguous set of dates)

[ameerbisyeed]

Current year sales & last year sales comparison product category wise sales percentage how

[decentmendreams]

Oh, I am so indebted for this video . I work in the hotel industry and half of my time I spend comparing YOY(Year Over Year) variances. This is. Eureka moment for me . Thank you very much . I have a Question. How would I go about calculating a revenue /room nights change from the last time I run my numbers . I know you are busy but thought I would give it a shot. Thank you again,

[likandoluywa]

Viewed several videos this was simple and best for Yr by Yr calculations
Power BI You have done wonders and helped me. Please keep it up mate!

[FalconFlyer]

do you have anything for previous Weekday?

for example lets say I want to compare the sales on Thusday December 10th 2020 to Thursday December 12th 2020

so comparing the weekday (mathematically all I need to do is subtract 364 days from the Date to get the prior year date) but I can't find anything in DAX that would allow me to do this