How calculate Number of users active in the month that were also active in the preceding month

[Cobra77]

Hi,

How calculate Number of users active in the month that were also active in the preceding month ?

With one table , how do a join on Name ?

Sample data :

https://1drv.ms/u/s!AmluE3Tt6h4WgjEZRf1mCHsTbyQQ?e=kDaeQE

Thanks for your helps

Best Regards

[mwegener · Accepted solution]

Hi @Cobra77 ,

you can calculate it like this

DistinctCount ThisMonth + DistinctCount LastMonth - DistinctCount BothMonth

Nb Users Full Period = CALCULATE (

[Nb Users];

FILTER(ALL('Calendar');

'Calendar'[Date] <= MAX('Calendar'[Date])

&& MONTH('Calendar'[Date]) >= MONTH(MAX('Calendar'[Date]))-1

))

NB MoM = [Nb Users]+[Nb users Previous Month] - [Nb Users Full Period]

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.