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
SarahESkells
Frequent Visitor

Changing data format from several columns to one appended column

Hello, I have some data that has appointments and a delimited list of users for said appointment in one column. I can split out the attendees into individual columns but I want to then be able to count how many meetings each individual has. Example below of what I am trying to achieve

 Attendee Query.PNG

Thank you

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@SarahESkells , Split by delimiter in power query and then use matrix visual

 

Split Column Power Query: https://youtu.be/FyO9Vmhcfag

View solution in original post

2 REPLIES 2
SarahESkells
Frequent Visitor

 This is perfect, thank you

amitchandak
Super User
Super User

@SarahESkells , Split by delimiter in power query and then use matrix visual

 

Split Column Power Query: https://youtu.be/FyO9Vmhcfag

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.