Forum Discussion
Weekly YOY comparison - chart
Hi,
I have chart with sales like below.
(months named in Polish)
Now, I want to create comparison but weekly.
For example, Week 3/2019 vs Week 3/2020.
For all I know, to compare Sales from previous year, I need contiguous dates, but date hierarchy from date table only works for Years, Months, Quarters and Days.
Is there any way to resolve this?
9 Replies
As long as you are grouping the measures on the week, you can use a 364 days behind measure for last year
364 days behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,Day))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedinamitchandak
What do you mean by "grouping the measures on the week"?If you visualize it week wise then last year's week will be plotted correctly. But this can not be used when data is viewed month wise.
