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'm using the following measure to calculative Cummlative Sum..
Cumulative Actual(ETS) = CALCULATE(CALCULATE(sum('Main Table'[OrderValue]),FILTER(ALL('Calendar'[Date].[Date]),'Calendar'[Date].[Date]<=MAX('Calendar'[Date].[Date]) )) , 'Calendar'[FiscalYear] = "FY17")
My requirement is, I'm using a Date slicer in the Dashboard UI and I'm looking for a measure that calculates the Cummulative Amount between the dates mentioned by User. Please help.
Solved! Go to Solution.
@kkalyanrr,
Please check the modified PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1Nok3Ll8CzEooAPooVx
Regards,
Lydia
Please change your DAX to the following:
Cumulative Actual(ETS) = CALCULATE(CALCULATE(sum('Main Table'[OrderValue]),FILTER(ALLSELECTED('Calendar'[Date].[Date]),'Calendar'[Date].[Date]<=MAX('Calendar'[Date].[Date]) )) , 'Calendar'[FiscalYear] = "FY17")
Regards,
Lydia
Hi @v-yuezhe-msft ,
How do you create this measure for the same period last year?
Thanks a lot!
Fernando
Hello @v-yuezhe-msft ,
No matter what the starting date in the Slicer, this measure always sums the values from first date in the dataset to end date..
But I'm looking for a measure where when user gives a i/p date , it should sumup the values from that date to end date..
Thanks,
Kalyan..
@kkalyanrr,
When you change ALL function to ALLSELECTED function, the measure should change based on your date slicer. Would you please share sample data of your table so that I can test?
Regards,
Lydia
Hello @v-yuezhe-msft ,
Please find it here
https://drive.google.com/file/d/1ZqgzNnzyuOVQgbeUPH5si3Khc5Sd9OlW/view?usp=sharing
@kkalyanrr,
Please check the modified PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1Nok3Ll8CzEooAPooVx
Regards,
Lydia
The link doesn't seem to work. Do you mind reuploading the solution?
Thank you,
@xyz123ABC ,
Please open a new thread describing your issue.
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |