Forum Discussion
Count the relationships
I need to figure out the number of patients I have with different benefit plans and which or primary, secondary or tertiary. I have the following columns
Benefit Plan Name, Patient and Benefit Plan Priority.
I am new to Power BI so this might be simple but I appreciate your help.
maybe you can try this in PQ.
1. sort the benefit plan name column
2. create a new column to combine benefit name and priority column
=[Benefit Name] & " "&[Benefit Plan Priority]
3. group by
= Table.Group(#"Added Custom", {"patient name"}, {{"Benefit", each Text.Combine([Custom],","), type text}})
at last, you can use distinctcount or remove duplicates to get the benefit combination amount.
pls see the attachment below
4 Replies
bwhiteaccess
Can you provide sample data and expected output?
Regards,
NGWe have about 250 different benefit plans. Some patients have multiple plans, some being primary and others being secondary.
What I need to know is what combonations we have and how many there are.
Example - Joe S. has United Healthcare primary and Medicaid secondary.
Thanks
Thank you.
maybe you can try this in PQ.
1. sort the benefit plan name column
2. create a new column to combine benefit name and priority column
=[Benefit Name] & " "&[Benefit Plan Priority]
3. group by
= Table.Group(#"Added Custom", {"patient name"}, {{"Benefit", each Text.Combine([Custom],","), type text}})
at last, you can use distinctcount or remove duplicates to get the benefit combination amount.
pls see the attachment below
