Count repeat physicians from previous quarter

[asandor]

I have a table with entry_time, PhysicianID and SalesRep. 

Im trying to see the count of PhysicianID from physicians that were users in the previous quarter and this quarter (Q2, Q3).

**Confidential info so can't provide screenshot of data. entry_time, PhysicianID and SalesRep are exact column names. 

[v-kkf-msft · Accepted solution]

Hi @asandor ,

Please create a date table: Calendar = CALENDAR( DATE ( 2021, 9, 1 ), TODAY () )

Then create these measures.

Q2 = 
CALCULATE (
    COUNT ( 'Table'[PhysicianID] ),
    DATEADD ( DATESQTD ( 'Calendar'[Date] ), -1, QUARTER )
)

Q3 = 
CALCULATE ( COUNT ( 'Table'[PhysicianID] ), DATESQTD ( 'Calendar'[Date] ) )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@asandor , check if customer repeat logic can be applied in your case. Use datesqtd in place of datesmtd

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...