Running Total

[Vishal_Chauhan]

Hello,

I am not getting the running total from Dec'2015 till Oct'18. I have checked all the partion in Tabular editor data is showing from 2015 till today (Nov'22). I have implemented the Incremental policy in my Fact table (84 months). please see the below relationship b/w tables. 

Total members count are showing in the table visual as per the Year month from date table but as soon as i drag the "club number" from Club table this will exclude the data from 2015 to Oct'2018 and rest data is showing from Nov'2018 till today.  

DAX which I have created to calculate the Running total is- 

Total Members =

VAR MaxDate = MAX('DATE TABLE'[FullDate])

RETURN

CALCULATE(

    SUM('MTD Membership Type Summary'[TOTAL_COUNT]),

    'DATE TABLE'[FullDate] = MaxDate

)

[mangaus1111]

Hi @Vishal_Chauhan ,

if you need the running total you have to write  'DATE TABLE'[FullDate] <= MaxDate as a condition in your DAX.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.