Forum Discussion
Weekday Last Year Comparison
Hi everybody ! I have a requeriment that i don't know how to achieve. Question is simple, how can I compare this year sales with exactly the same weekday sales of last year. take for instance, To...
Dear Anonymous,
Thank you, this is great.
The only challenge I have is that my last year based on your number. 7 has one drawback.
Net Sales LY test = CALCULATE([Net Sales test];FILTER(ALL('TestDWH Date');'TestDWH Date'[DWY] = MAX('TestDWH Date'[DWY])-1))
When I have it on days, i.e. monday, tuesday etc, my "total" row in f.ex. a table only show value for sunday LY. Do I need any IF statement?
Thank you,
Mikkel
Hi Mikkelnaes
Could you please post your pbix in one drive / google drive and share the link.
Please also explain what is not working correctly.
Cheers
CheenuSing