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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
baneworth
Helper II
Helper II

Power Query column merging

Dear Community,

 

i am facing an issue where i tried a few ideas but couldnt figure out the solution.

 

As you can see in the image i have Responsible ID = Names and Responsible Remark = tells me which shift -> either S1 or S2.

 

I have a tool ID where each ID has a S1 and a S2 responsible. Now i want to achieve the S1 & S2 responsible in the same column and row.

 

S1&S2.jpg

 

If there is a solution, could you please help me out.

 

Thank you

 

Best regards

Matthias

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@baneworth , BAsed on what I got.

Refer if power query option can help

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@baneworth , BAsed on what I got.

Refer if power query option can help

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

Thank you, it solved my issue

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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