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)))
JW_van_Holst's avatar
JW_van_Holst
Icon for Resolver IV rankResolver IV
3 years ago

ISONORAFTER is a utility function. Do not use it in measures. 
Try:

RT =
VAR LastVisibleDate =
    MAX ( 'calendar'[Date] )
VAR PeriodToUse =
    FILTER ( ALL ( 'calendar'[Date] ), 'calendar'[Date] <= LastVisibleDate )
RETURN
    CALCULATE ( SUM ( Actuals[Actual] ), PeriodToUse )