Forum Discussion

jpereztang's avatar
jpereztang
Helper I
10 years ago

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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello,

 

I have used your solution, it works great. The only issue is that now I am trying to aggregate it per month as well.

 

To get the sales for last year I am using this:

 

Sales Last Year = SUMX(VALUES('Calendar'[DWY]),Calculate(SUM('Sales & Tickets'[Sales]), Filter(ALL('Calendar'),Calendar[DWY] = MAX(Calendar[DWY])-1 )))

 

Unfortunately when drilling through from day to month data is slightly inaccurate. Any idea how to solve this issue?

 

Again, thank you for your previous solution, it was extremely helpful!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

For those interested, I replaced the MAX by the function EARLIER that I just discovered (which by my understanding we could actually almost always call current row).

  • PBIUser135's avatar
    PBIUser135
    Frequent Visitor
    6 years ago

    That bit on using the EARLIER function to get the right total when using this as a combined measure just made my month! I owe you big time!