Forum Discussion
manar_alamri
Helper I
Helper ICustomers 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...
lucadelicio
Impactful Individual
Impactful IndividualHi 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.
manar_alamriHelper I
Helper IThank you lucadelicio the new client measure is work !
can you help me on Customers retention also ?