Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Aggregate daily SSS by month

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 :).

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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