Aggregate daily SSS by month

[Anonymous]

Hello,

I have computed daily SSS using the solution in this post which works great:

http://community.powerbi.com/t5/Desktop/Weekday-Last-Year-Comparison/td-p/54561

However I can't aggregate it properly when I use the drillthrough to go back to months. This the formula I am currently using:

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

Results are close but not matching. 

Any help welcome :).

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Based on your reply in the similar thread you post, it seems that you have solved the issue by replacing the MAX function with EARLIER. If you solved this issue, please accept appropriate reply as answer to close this thread.

Regards,
Lydia