Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cumulative Sum - Dax Query

  Hello. I am trying to create a chart that shows the Cumulative sum of Apps Created over time.   How can I do it with Dax query ?   So far, I created the below chart which gives the Count of Ap...
General Comment
Need Help
Tips and Tricks
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    PLease try

    Cumulative Sum =
VAR CurrentDtate =
    MAX ( 'App'[admin_appcreatedon] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'App'[admin_appid] ),
        'App'[admin_appcreatedon] <= CurrentDtate,
        'App'[admin_appdeleted] = "True",
        ALL ( 'App' )
    )
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 
PLease try

Cumulative Sum =
VAR CurrentDtate =
    MAX ( 'App'[admin_appcreatedon] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'App'[admin_appid] ),
        'App'[admin_appcreatedon] <= CurrentDtate,
        'App'[admin_appdeleted] = "True",
        ALL ( 'App' )
    )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello tamerj1 , thank you for the help. It did help me a lot.