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)))
MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi Anonymous ,

 

Believe you have the syntax of the ISONORAFTER incorrect try the folllwing:

 

Actual RT =
CALCULATE (
    SUM ( Actuals[Actual] ),
    FILTER (
        ALLSELECTED ( 'calendar'[Date] ),
        ISONORAFTER ( MAX ( 'calendar'[Date] ), desc )
    )
)

 

Anonymous's avatar
Anonymous
Not applicable
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)))