Forum Discussion
Running total until Today
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.
sure, works fine as yours but same problem.
show the correct value but for all the dates, i just need to show it in current month
If you only want the values to be visible in the current month (and year), try:
Running total upto and including Today in current month (and year) =
VAR RunningTotal = CALCULATE(sum('Liquidità'[Liquidità]);
FILTER(ALL('Calendar');
'Calendar'[Date] <= TODAY())
)
RETURN
CALCULATE (RunningTotal;
FILTER ('Calendar';
'Calendar'[Month] = MONTH(TODAY())
&&
'Calendar'[Year] = YEAR(TODAY())
)
)it return an error
mdxScript(Model)(44,1) calculation error in the measure. DAX comparison operations do not support the text type comparison with Integer type values. Try using the VALUE or FORMAT function to convert one of the values
You need to substitute the column references in the measure with whatever equivalent columns you have in your calendar table:
'Calendar' = <<your calendar table>>'Calendar' [Month] = the column which is the Month as an integer in your Calendar table
'Calendar' [Year] = the column which is the Year as an integer in your Calendar table
still show the value on all dates