Forum Discussion

Tiago_Varela's avatar
Tiago_Varela
Icon for Helper I rankHelper I
6 years ago

NEW Costumers PER MONTH

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    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
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

    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]