I have the data in following format where column 1 is username and column 2 is platforms. I want to create a venn diagram in Power Bi. For that I need to
Format in which I have the data:
User Name | Platforms |
---|---|
User 1 | |
User 3 | |
User 1 | |
User 3 | |
User 2 | YouTube |
User 4 | |
User 1 | YouTube |
User 3 | YouTube |
User 1 | YouTube |
User 3 | YouTube |
User 1 | |
User 3 | |
User 1 | |
User 3 | |
User 1 | |
User 3 | |
User 1 | |
User 3 |
Format in which I want to arrange the data:
Any help would be appretiated.
I can do this in excel but the problem is that this is a part of larger dataset and hence need to do this programatically through DAX.
Try the following as a Calculated Table: This one is more unique users:
And this one is more user instances (aka visits):