Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Newby here... how can i change this expression to sum values between dates selected in my filter. i assume i need a min in their somewhere. appreciate your help.
Solved! Go to Solution.
@pc1 Create a calculated column using the following DAX. You will be able to get the cumulative sum.
Month = FORMAT(FinData[Date],"mmm-YYYY")
@pc1 Do you have a Date column in your FinData table? In that case, the following code will return the cumulative sum of Fcast Dec column for dates selected in the slicer.
Cumulative Quantity = SumX( FILTER ( ALLSELECTED('FinData'[Date]), 'FinData'[Date]<=MAX('FinData'[Date]) ), CALCULATE(SUM([Fcast Dec])) )
i dont have date but i have a mmm-yy column in text. I have the same mmm-yy column in my calendar table for sorting the time series in all my charts.
i've played with your formula with constructed date data and whilst it seems to work on dates it does'nt work with my mmm-yy (as text) column. Do you know why this might be the case?
cheers
@pc1 Create a calculated column using the following DAX. You will be able to get the cumulative sum.
Month = FORMAT(FinData[Date],"mmm-YYYY")
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |