Forum Discussion
Running Total starting from Measure
Hi Maybe one of you can help me with by calculation. I have a running total starting from measure, dax function is working as expected, Measure calculation should start from value 149.421 and d...
use this as the last line of your code.
RETURN IF ( HASONEVALUE ( Table[DateColumn] ), Result )
This code will return blank for the grand total section. More specifically, whenever there is more than 1 date in the filter context.
Modify the Table[DateColumn] with the appropriate table name and column name (I'm not sure if you're using a calendar table, or just the date in your fact table).
Nice job using variables in your DAX, makes it much easier to read and troubleshoot!