Forum Discussion
Count the relationships
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
We 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.
Super Usermaybe 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