Forum Discussion

Vishal_Chauhan's avatar
Vishal_Chauhan
Frequent Visitor
3 years ago

Running Total

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
)

 

Need Help

1 Reply

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    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.