Forum Discussion
Helper IIYear Over Year Percent Change By Week
Well it looks like you're already part way there, since you have the week number. Instead of using the builtin SAMEPERIODLASTYEAR calculations, you get to make your own!
You can take a look at this answer for a starting point of how to get a difference between the current row value and the previous row value: https://community.powerbi.com/t5/Desktop/Power-BI-Running-Totals-Kinda/m-p/719274#M347104
Your case should be simpler than that one, but it has the same idea of finding the difference between the number of people in the current year and the number of people in the previous year while still staying within the same group of weeks.
Resident RockstarWell it looks like you're already part way there, since you have the week number. Instead of using the builtin SAMEPERIODLASTYEAR calculations, you get to make your own!
You can take a look at this answer for a starting point of how to get a difference between the current row value and the previous row value: https://community.powerbi.com/t5/Desktop/Power-BI-Running-Totals-Kinda/m-p/719274#M347104
Your case should be simpler than that one, but it has the same idea of finding the difference between the number of people in the current year and the number of people in the previous year while still staying within the same group of weeks.