Forum Discussion

rsrgerge's avatar
rsrgerge
Regular Visitor
3 years ago
Solved

Modifying Cumulative Measure

HI,   I want try and modify the below cumulative measure to ignore dates after a certain point (Today's date). The measure provides a cumulative sum of a value against the report date. I want to tr...
Need Help
  • pankaj_lp's avatar
    pankaj_lp
    3 years ago

    Try using this :

    Cash In Cumulative =
    VAR MaxReportDate = MAX('Cash_View'[Report Date])
    VAR CutOffDate = TODAY()

    RETURN
    CALCULATE(
    SUM('Cash_View'[Amount]),
    FILTER(
    ALLSELECTED('Cash_View'[Report Date]),
    ISONORAFTER('Cash_View'[Report Date], MaxReportDate, DESC)
    && 'Cash_View'[Report Date] <= CutOffDate
    ),
    'Cash_View'[InOut] = "Cash In"
    )

pankaj_lp's avatar
pankaj_lp
Helper I
3 years ago

try changing the maxreportdate to today() itself

 

rsrgerge's avatar
rsrgerge
Regular Visitor
3 years ago

It has the same effect, it flattens the line and can't correctly plot the week by week cumulative sum 

 

  • rsrgerge's avatar
    rsrgerge
    Regular Visitor
    3 years ago

    pankaj_lp 

     

    Solved it thanks to your help, I realised i had to apply the filter to the variable to get the Max Report Date relative to that value type. Thanks for your help!

    MaxReportDate = CALCULATE(MAX(Cash_View[Report Date]),Cash_View[InOut]="Cash In")