Forum Discussion

mauroanelli's avatar
mauroanelli
Helper I
8 years ago
Solved

Running total until Today

hi all , i use this formula for running total rt Liquidità = CALCULATE(sum('Liquidità'[Liquidità]);FILTER((ALL('Calendar'[Data].[Date]));'Calendar'[Data].[Date] <= MAX('Calendar'[Data].[Date]))) bu...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    8 years ago

    mauroanelli

     

    I see, yes. Sorry about that. I've just tested the following measure and it will return the cumulative value and display it only on the current month (and year):

    Running total upto and including Today in current month (and year) =

VAR RunningTotal = CALCULATE(sum('Liquidità'[Liquidità]);
FILTER(ALL('Calendar');
'Calendar'[Date] <= TODAY())
)

RETURN
IF(MAX('Calendar'[year]) = YEAR(TODAY())  &&  MAX('Calendar'[month] ) = MONTH(TODAY()); RunningTotal ; BLANK())


    I hope that works. Sorry about the mistake.

    Regards,

    Paul.

PaulDBrown's avatar
PaulDBrown
Community Champion
8 years ago

Hi mauroanelli

 

I'm not sure if you need the total upto and including today's date or this month. Choose which meets your requirement:

Running total upto and including Today

CALCULATE(sum('Liquidità'[Liquidità]);
FILTER(ALL('Calendar');
'Calendar'[Date] <= TODAY())
)
Running total upto and including this month =

CALCULATE(sum('Liquidità'[Liquidità]);
FILTER(ALL('Calendar');
'Calendar'[Month] <= MONTH(TODAY()))
)