Forum Discussion

asandor's avatar
asandor
Regular Visitor
4 years ago
Solved

Count repeat physicians from previous quarter

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. 

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

2 Replies