Forum Discussion
Customers Retention by quarters
Hello everyone , I want to do two things in power bi : first , calculate the customer retention by quarters , years and centers( Customers who returned from the previous quarter to the same cente...
Hi manar_alamri
try this measure:
New Clients =
CALCULATE(
DISTINCTCOUNT(Table1[guest code]),
FILTER(
Table1,
Table1[date] =
CALCULATE(MIN(Table1[date]),
ALLEXCEPT(Table1, Table1[guest code])
)
)
)
put in a table with the period column that you need.
put in a table with the period column that you need.
Thank you lucadelicio the new client measure is work !
can you help me on Customers retention also ?
