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' )
    )
Fahad12's avatar
Fahad12
Frequent Visitor
3 years ago

From where did you get admin_appdeleted column? it wasn't mentioned in the original post or am I missing something

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Fahad12 
Perhaps I got it through mail or private message or sometimes I connect with the post owner via teams or zoom. To be honest, I don't remember 🙂