Forum Discussion
Calculation New, Repeat Customer
Hi BI Community Team, I have a sales order table (Aug'23 till Oct'23), with this I have created a measure below to find the customer purchased: Customer Purchased = CALCULATE(DISTINCTCOUNT('...
In the month filter drop down, select only one month - October. Both those codes have transactions in September and therefore for the month of October, they should both be classified as Repeat.
Hi Ashish_Mathur,
One customer have multiple sales team serviced (sell different brand/category), if you check this customer code: CT01718 will see transcation from Aug till Oct. But we filter by sales team = Food1, Brand = Kingfisher then have transcation in Aug & Oct.
So if we're standing in Oct, then this customer is New because no transcation in Sep.
Please check and advise.