This Year VS Last Year Time Comparisons & Differences In Power BI

Today, I’ll demonstrate how you can easily calculate This Year VS Last Year, or any time comparison in general, with a couple of techniques. This I believe is one of the first skills I think you should work through as you’re learning how to operate DAX effectively in Power BI Desktop.

Sam

***** Video Details *****
00:00 Introduction
00:44 Waterfall technique
01:35 Creating a core measure
02:20 SAMEPERIODLASTYEAR function
03:52 Year on Year with measure branching
04:42 Creating visualization
05:05 Creating a slicer for a specific month
05:50 The AnalystHub
06:25 Last Year quantity with DATEADD

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

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

[alexxander]

Best Dashboard Tutorial ever, no wasting time, no hard word or anything, just pure knowledge. Keep it up bro you are the best

[golnazqasemzadeh]

This was the only training video that actually helped me completing my BI Dashboards. Thank you.

[DarkessMyOldFriend]

very useful, i have spent days on thinking the filter logic until i saw your tutorial.

[MikeCummings-kink]

Very informative. What if we want to compare 2 different years and let the user pick the years? So they could pick 2022 vs 2018 instead of being Year selected vs PY, which is helpful. Nice vid, quick, concise, no BSing.

[Avinashkraj]

Excellent..you saved my time ..thank you

[BrianReyes-rn]

Hello, this is the solution I am looking for, but when I add the Last Year measures i create, I am getting Null values (only current year populates).

Could this be because I am using a view in SQL as a source with all the fields needed, rather than making the joins within Power BI?

[zafariqbalsyed]

Dear Sir its very informative video thanks and good luck

[robrayborn]

As always, very helpful. What would you do if you wanted to compare Work Days this year to same amount of Work Days (WeekDays - Holidays) from the previous year?

[Tmvv]

Hi, thank you very much for your tutorial. What if I am dealing with a measure which uses distinct count (on some id)? Problem emerges when a single id might span across several dates.

[derekventura]

How would you do this if you wanted products in the rows (TVs, Computers, etc.) instead of the dates with the columns being CY and PY like you have it ? Trying to do a Price volume mix analysis

[satishkumardommeti]

Great exaample of comparison between two sets of data. I have a challenge to write a DAX measure for this variant of the problem. Let me say we are currently in Sept 2020 and my Filter selection is 2020 calendar year. I would like to compare CY Sales (Jan - Sep 2020) vs LY Sales (Jan - Sep 2019) and not Jan - Dec 2019. What is the best suited DAX function?

[muhammadatiq-ur-rehman]

Thanks for your video, i have table with range of dates and i want to do Comparisons last 5 days vs current 5 days . is this possible ? like

[MiguelGonzalez-ophv]

What if my dates are not the same? I have a dataset using the "Week Start Date", since the week date doesn't start on the same date year over year, should i use a different date metric? Ex. YearWeek or Weeknumber? Thanks in advance!

[kennethsmith]

Is a single date table sufficient or do you need a date table specific for each time specific measure?

[michaelabarbosa]

It worked perfectly on one of my data sets but when I repeated the same steps for another data set (in the same report) the table displays the Total Quantity and Quantity LY on separate lines, although they are in they should be on the same line. Basically my entire date column is doubled and Total Quantity is on every other line. My Quantity LY is on every line the Total Quantity is not on.

The time intelligence calculations I try to complete are then inaccurate because of the issue mentioned above.

[CHQAQC]

What do I need to modify if I have multiple slicers (Time period and Product type) to dynamically change the previous year. The Total Sales changes accordingly but not the Total Sales PY when Product type is filtered

[giri]

If statement not working with sumx please help

[neha]

why im getting same values for both last yr n this yr?

[lloydmadima]

Hi all, anyone to assist so I created quantity for last year but when I start toggling on the filter between years that entire column becomes blank, only when I do not have any year selected I get to see by scrolling down the table but soon as I use the year filter it becomes blank.