Forum Discussion

manar_alamri's avatar
manar_alamri
Icon for Helper I rankHelper I
1 year ago

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...
Need Help
lucadelicio's avatar
lucadelicio
Icon for Impactful Individual rankImpactful Individual
1 year ago

As attachment the pbix file.
Try this measure:

Customer Retention by Quarter =
VAR CurrentQuarterStart = STARTOFQUARTER(Table1[date])
VAR CurrentQuarterEnd = ENDOFQUARTER(Table1[date])
VAR PreviousQuarterStart = STARTOFQUARTER(DATEADD(Table1[date], -1, QUARTER))
VAR PreviousQuarterEnd = ENDOFQUARTER(DATEADD(Table1[date], -1, QUARTER))
VAR Center = SELECTEDVALUE(Table1[Center])
VAR PreviousGuest =
CALCULATETABLE(
    DISTINCT(Table1[guest code])
    ,ALL(Table1)
    ,Table1[date] >= PreviousQuarterStart && Table1[date] <= PreviousQuarterEnd,
    Table1[Center] = Center
)

RETURN
CALCULATE(
    DISTINCTCOUNT(Table1[guest code]),
    FILTER(
        ALL(Table1),
        Table1[date] >= CurrentQuarterStart && Table1[date] <= CurrentQuarterEnd &&
        Table1[guest code] IN PreviousGuest
    )
)
  • manar_alamri's avatar
    manar_alamri
    Icon for Helper I rankHelper I
    1 year ago

     lucadelicio  Still I faced an issue 

     the result appears blank 

    I dont know why 

     

     

  • manar_alamri's avatar
    manar_alamri
    Icon for Helper I rankHelper I
    1 year ago

    lucadelicio 

    I tried to remove the center (  Table1[Center] = Center) 

    and it is work

    but i need it by centers