cumaltive total active users with aggregation to TOTALMTD function

[giladmagori]

Hi,

I try to present the total cumlative active users month over month on a visual.

i used the table:

I already defined a measure as:       Total month = TOTALMTD(sum('join'[Status]),'join'[Date]),

This measure present the total active user per month without based on the total of previous month.

Can you please help me using my current measure (Total month = TOTALMTD(sum('join'[Status]),'join'[Date])) and upgrade it to be able to present the total cumlative active users month over month??

Thank a lot,

Gilad

[v-huizhn-msft]

Hi @giladmagori,

Have you resolved your issue? Please clear more details, so that we can provide the solution which is close to your requirements.

Best Regards,
Angelia

[hemantsingh]

hi @giladmagori,

    I understood from your visual that -1 is for inactive & +1 is for active person ,right?? Further you need to add all people who has flag as + 1 cumulatively..correct??

[Greg_Deckler]

So that I am clear, you want a running total of users month over month such that if you had 10 users in the previous month and 15 in the current month that you would report 10 for the previous month and 25 for the current month? Is that correct or not?