NEW Costumers PER MONTH

[Tiago_Varela]

Hello everyone,

I´m trying to get the new number of new custumers per month.

I have a date table and a tables with the number od costumers per day

so i have on the main table:

january: 2500 costumers

february: 3500 costumers

march: 4000 costumers

and so on.

I need a dax formula that give me the new costumers i have in february (1.000 new costumers) in March (500 new costumers), and so on.

Can anyone help me?

Thanks

[Anonymous]

JanCount =CALCULATE(DISTINCTCOUNT('Table'[UniqueCustomerID]), 'Table'[Date].[Month] = "1")

Make one for each month then you can add or subtract or whatever you need to do. 

MonthChange = [JanCount]-[DecCount]

[Anonymous]

With this data, it's not possible. To know the new customers in a period of time you have to have a means of identifying customers.

Best
D