Forum Discussion
Repeat and New Customers
Hi so I used a model that came from power BI titled New and Repeat Customers that would help you create a table of new customers, their sales, repeat customers, their sales, but the calculation only does it by month and I need it by year. I also only want to include the very first time a customer gave not if they gave again within that year but only count their very first purchase. It is counting all of my customers as new customers instead of splitting it into the repeat and new like the formula I used did. I need just need it year to year and only the gifts that were given for the first time even if they donated again within that year later.
Hi RimeClark ,
As there is no data for your template, you can refer to the following,it will determine whether a user is new or old based on the time period selected by the slicer.
Create theb below measure:
TEST = if(CALCULATE(COUNT('Table'[Id]),ALLSELECTED('Table'),'Table'[Id]=MAX('Table'[Id]))>=2,"RepeatCustomers","New Customers")Output result:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
1 Reply
- v-luwang-msft
Community Support
Hi RimeClark ,
As there is no data for your template, you can refer to the following,it will determine whether a user is new or old based on the time period selected by the slicer.
Create theb below measure:
TEST = if(CALCULATE(COUNT('Table'[Id]),ALLSELECTED('Table'),'Table'[Id]=MAX('Table'[Id]))>=2,"RepeatCustomers","New Customers")Output result:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien