Forum Discussion
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...
Hi Anonymous
PLease tryCumulative Sum = VAR CurrentDtate = MAX ( 'App'[admin_appcreatedon] ) RETURN CALCULATE ( DISTINCTCOUNT ( 'App'[admin_appid] ), 'App'[admin_appcreatedon] <= CurrentDtate, 'App'[admin_appdeleted] = "True", ALL ( 'App' ) )
tamerj1
Community Champion
Community ChampionHi 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' )
)
From where did you get admin_appdeleted column? it wasn't mentioned in the original post or am I missing something