Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pmazara
Frequent Visitor

How to create a pivot from 2 columns (source table) - note attached screenshot

Trying to create a pivot from 2 columns (from source table) -> note that the second column has repeat enteries

 

Need to DistinctCount the skill type against each user so as to create a pivot per custom Table 2 

 

This is to satisfy the data format required for the venn visual

 

Query.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi there - 

 

I have tried using the sample data attached in your screenshot and tried to get the output you were looking for. Please find the file uploaded here - https://drive.google.com/file/d/1nVIXsZaHUkOsB4_S3kex9_pVuE7QNvD6/view?usp=sharing

 

Once accessed, please let me know so that I can delete the file from there. If the above solution helped you, please accept this as a solution.

 

Regards

E

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

One is that you use matrix visual and drag one on row and another on the column. Drag one of these again in values and take count.

 

You want change the table structure

https://radacad.com/pivot-and-unpivot-with-power-bi

Anonymous
Not applicable

Hi there - 

 

I have tried using the sample data attached in your screenshot and tried to get the output you were looking for. Please find the file uploaded here - https://drive.google.com/file/d/1nVIXsZaHUkOsB4_S3kex9_pVuE7QNvD6/view?usp=sharing

 

Once accessed, please let me know so that I can delete the file from there. If the above solution helped you, please accept this as a solution.

 

Regards

E

Hi E @Anonymous,

 

This is great. Just need your help with one more step to complete the solution -> how to get distinct count for each skill type ?

 

The Venn visual only works with binary values

 

Thanks,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.