Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX function

Hey all, Im trying to create a Running Total (RT) function for Actuals, Budget and Forecast data. I have included the following function:  Actual RT = calculate(sum(Actuals[Actual]), Filter(ALLSELE...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    MFelix this worked for me:

     

    Actual RT = Calculate(SUM(Actuals[Actual]),FILTER(ALLSELECTED('Calendar'[Date]), ISONORAFTER('Calendar'[Date],MAX(Actuals[Date]), DESC)))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

MFelix thats correct I couldnt recover the file since it it was broken.