Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 :).
Solved! Go to 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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |