Forum Discussion

ribisht17's avatar
ribisht17
Icon for Super User rankSuper User
2 years ago
Solved

Running Total not working as expected

Hello Datafam,   amitchandak    I have the below scenario where I need to calculate RUNNING total,   It not giving me the exact output as I was looking for     See the Yellow...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    ribisht17 , Make sure that Year, Qtr, and month are from the 'Certification Calendar Date' and it not a from a Auto date hierarchy , There should be columns from 'Certification Calendar Date' 

     

     

    few version

     

    CALCULATE(
    sum('Master Certification Tab'[Certification Count_C]),
    FILTER(
    ALLSELECTED('Certification Calendar Date'[Cert Calendar Date]),
    'Certification Calendar Date'[Cert Calendar Date]<= Max('Certification Calendar Date'[Cert Calendar Date])
    )
    )

     


    CALCULATE(
    sum('Master Certification Tab'[Certification Count_C]),
    FILTER(
    all('Certification Calendar Date'[Cert Calendar Date]),
    'Certification Calendar Date'[Cert Calendar Date]<= Max('Certification Calendar Date'[Cert Calendar Date])
    )
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

ribisht17 , Make sure that Year, Qtr, and month are from the 'Certification Calendar Date' and it not a from a Auto date hierarchy , There should be columns from 'Certification Calendar Date' 

 

 

few version

 

CALCULATE(
sum('Master Certification Tab'[Certification Count_C]),
FILTER(
ALLSELECTED('Certification Calendar Date'[Cert Calendar Date]),
'Certification Calendar Date'[Cert Calendar Date]<= Max('Certification Calendar Date'[Cert Calendar Date])
)
)

 


CALCULATE(
sum('Master Certification Tab'[Certification Count_C]),
FILTER(
all('Certification Calendar Date'[Cert Calendar Date]),
'Certification Calendar Date'[Cert Calendar Date]<= Max('Certification Calendar Date'[Cert Calendar Date])
)
)