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' ) )
Hello tamerj1 ,
Thank you for responding. I did try the code, but something is not matching with Values.
How to exclude values from Table 'App' where admin_appdeleted is equal to true from the below code ?
Cumulative Sum =
VAR CurrentDtate =
MAX ( 'App'[admin_appcreatedon] )
RETURN
CALCULATE (
DISTINCTCOUNT ( 'App'[admin_appid] ),
'App'[admin_appcreatedon] <= CurrentDtate,
ALL ( 'App' )
)
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' )
)Hello tamerj1 , thank you for the help. It did help me a lot.
From where did you get admin_appdeleted column? it wasn't mentioned in the original post or am I missing something
