Forum Discussion
Solved
From multiple rows to summary table
Hi,
I thought I have a simple problem, but cannot get my head around it - I have one table with company - service pairs
| Company | Service |
| Company A | Service A |
| Company A | Service B |
| Company A | Service A |
| Company A | Service C |
| Company B | Service E |
| Company B | Service E |
| Company B | Service E |
| Company B | Service A |
| Company B | Service C |
| Company B | Service E |
| Company B | Service D |
| Company B | Service A |
| Company C | Service E |
| Company C | Service D |
| Company C | Service A |
| Company C | Service E |
| Company C | Service B |
and I'd like to get a simple summary table as a result:
| Company | Service A | Service B | Service C | Service D | Service E |
| Company A | true | true | true | false | false |
| Company B | true | false | true | true | true |
| Company C | true | true | false | true | true |
What would be the easiest way to accomplish this (in Power BI Desktop).
Many thanks in advance !
I guess M will beat DAX this time as the better solution.
This video shows how it can be done in M via the Query Editor.
Thank you so much - absolutely great help with that step-by-step video!
3 Replies
I guess M will beat DAX this time as the better solution.
This video shows how it can be done in M via the Query Editor.
Thank you so much - absolutely great help with that step-by-step video!
You're welcome, but please mark the right post as the solution...