Forum Discussion
Find max practice per employee
Hello,
I have one table that includes Employee, Date, Location, etc. This table links to a Location table on Location ID. In the Location table is a field called practice. I need to find the for each employee, the practice they have the most locations for. For example, provider Smith goes to 10 locations, 6 belong to Practice A, 3 to Practice B and 1 to Practice C. I need to show Smith, Practice A.
1 Reply
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523