From multiple rows to summary table

[Harness]

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 !

[MarcelBeug · Accepted solution]

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.

[MarcelBeug · Accepted solution]

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.

[Harness · Accepted solution]

Thank you so much - absolutely great help with that step-by-step video!

[MarcelBeug]

You're welcome, but please mark the right post as the solution...