Forum Discussion

sumitnegi1266's avatar
sumitnegi1266
Frequent Visitor
3 years ago
Solved

Need help with DAX formula

Hi, I have below table and need to calculate below: 1. Calculate Cumulative Sum of Forecast Value till today's date i.e. 15th Aug 2. Add these i.e. 'Value to Add' + Cumulative Sum = 15 + 75 = 90 ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

    sumitnegi1266 , Hop you already have measure

     

    Cumm Sum = CALCULATE(SUM(Table[Value]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

     

    Date = Minx(Values('Date'[date]), if([Cumm Sum]>90, [Date], blank()))  -1

     

    or

     

    Date = calculate( Minx(Values('Date'[date]), if([Cumm Sum]>90, [Date], blank())) , allselected())  -1