Cumulative Sum - Dax Query

[Anonymous]

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 Apps created particular month !

• Y axis -  'App'[admin_appid]
• X axis -  'App'[admin_appcreatedon]

 

 

Kindly let me know how to create and plot the Cumulative sum of Apps Created over time.

[tamerj1]

HI @Anonymous 
PLease try

Cumulative Sum =
VAR CurrentDate =
    MAX ( 'App'[admin_appcreatedon] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'App'[admin_appid] ),
        'App'[admin_appcreatedon] <= CurrentDate,
        ALL ( 'App' )
    )

[Anonymous]

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' )
    )

[tamerj1 · Accepted solution]

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]

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

[tamerj1]

@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 🙂

[Anonymous]

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

[amitchandak]

@Anonymous , You need to create a measure like

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

or

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))