How to arrange the data in PowerBi using Dax in the below format?

[Anurag4659]

I have the data in the following format where column 1 is a username and column 2 is platforms. I want to create a Venn diagram in Power Bi. For that, I need to format the data.

Current Format of data:

Current Format

Required Format:

Required Format

Any help would be appreciated.

I can do this in Excel but the problem is that this is a part of a larger dataset and hence need to do this programatically through DAX.

[amitchandak]

@Anurag4659 , You can use pivot data in power query to get a new table

Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12

Or use matrix Visual with a platform on columns and count the platform as a value