Forum Discussion
Solved
Linking related items within the same table-Power Query
I need help with Power Query. I have a table with columns: A, B and C Column A and C contain identical items to be linked. I want column C to check where everything is in column A and show concate...
Hey mraka9 ,
here you will find the pbix file: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/EblF6V1lDU9Juds8936QHn4Bv2SHqj2_a1QhalXlXJyVqw?e=5kWRbf
Regards,
Tom
Hey mraka9 ,
if you change this line
Table.SelectRows( #"Changed Type" , each [C] = filtervalue )[B]to this
Table.SelectRows( #"Changed Type" , each [A] = filtervalue )[B]the function returns what you are looking for:
Regards,
Tom
Hello Tom,
can you upload the pbix file.
The language in Power BI is not English for me, so I can't just copy.
Thank you very much. That might be the solution I'm looking for!
Hey mraka9 ,
here you will find the pbix file: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/EblF6V1lDU9Juds8936QHn4Bv2SHqj2_a1QhalXlXJyVqw?e=5kWRbf
Regards,
TomWell done!
Thank you very much Tom!Greetings