The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a cumulative measure, and when I have the chart broken down to weeks the measure works as expected, but when rolling up to months my cumulative line continues to the end of the date field. Everything is calculating correctly, I just am not getting the actual cumulative line to stop at the data date.
By week:
By Month:
Here is the dax I am using:
Solved! Go to Solution.
Try changing SELECTEDVALUE to MAX. SELECTEDVALUE will return blank if multiple dates are visible in the filter context, and blank evaluates as less than any date.
THANK YOU! I've been searching all over for a solution for that, MAX worked.
Try changing SELECTEDVALUE to MAX. SELECTEDVALUE will return blank if multiple dates are visible in the filter context, and blank evaluates as less than any date.
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
11 | |
7 |