Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |