cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
amy_mcmasters Frequent Visitor
Frequent Visitor

How to count matching ID in same table from two different dates

Hello PBI Community, 

 

I have a table that contains as columns:

  • Report Effective Date
  • Employee ID

 

I need to count the distinct number of Employee ID who were in the table on Report Effective Date 1 AND Report Effective Date 2, to effectively create count of Retained employees over a given time period. The count should only return those employee IDs who matched from Date 1 and Date 2.

 

I would prefer the start and end Dates to be dynamic so that using a slicer I can adjust the report effective dates and the measure will recalculate the retention count based on any two report effective dates chosen. 

I appreciate your suggestions!

1 REPLY 1
Community Support Team
Community Support Team

Re: How to count matching ID in same table from two different dates

hi, @amy_mcmasters 

You could take a look at this post:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

If not your case, please share some sample data and your expected output.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,314)