Calculate no. of new subscribers each month

[hpayne93]

Hi,

I need to calculate the number of new subscribers month to month. So from Jan to Feb 2022 this would be 279.

How do I do this using DAX?

Thanks

[Vallirajap]

Hii @hpayne93 
I hope the first solution is usefull for you. Please mark as a solution for the first reply. so that it is useful for upcoming visitors who else need this solution.

In the above scenario, add a .[Date] in the Dateadd function after the Date column

Ex :  Dateadd( 'table'[Date].[Date], -1, Month)

Don't forget to hit the Mark as a solution and kudo

Thank you

[Vallirajap]

Hii @hpayne93 

To find the Month over month(MOM), use the below Dax

Measure 3 =

Var _Prev_Month = CALCULATE(SUM('Table (3)'[Total Subscriber]), DATEADD('Table (3)'[Date].[Date], -1, MONTH))

Var _MOM = Sum('Table (3)'[Total Subscriber]) - _Prev_Month

RETURN

_MOM

Screenshot:

Mark this as a solution

Thank you

[hpayne93]

Thanks for this!

It only seems to be showing total not the new subscribers for each month. Can you see where I'm going wrong?