Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have 2 column from 2 file and i want to combine data from 1 row in column 1 to all row of column 2.
Data 1
Column 1 |
A |
B |
C |
Data 2
Column 2 |
X |
Y |
Z |
Result
Result |
AX |
AY |
AZ |
BX |
BY |
BZ |
CX |
CY |
CZ |
Thank you for your time!
Solved! Go to Solution.
=List.TransformMany(Data1[Column1],each Data2[Column2],(x,y)=>x&y)
Hi @daicaboy
@wdx223_Daniel 's solution is great with only one step. It can give you the desired result in a list.
If you have interest in dealing with it with Power Query Editor GUI, you can try the following steps.
1. In "Data 2" query, add a custom column with #"Data 1"[Column 1]. This gives you a list of data from Data 1 query.
2. Expand the above custom column to new rows.
3. Add the second custom column to combine values of two columns with &.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Wow, thank you guys, it help me a lot. I appreciate it !
Hi @daicaboy
@wdx223_Daniel 's solution is great with only one step. It can give you the desired result in a list.
If you have interest in dealing with it with Power Query Editor GUI, you can try the following steps.
1. In "Data 2" query, add a custom column with #"Data 1"[Column 1]. This gives you a list of data from Data 1 query.
2. Expand the above custom column to new rows.
3. Add the second custom column to combine values of two columns with &.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
=List.TransformMany(Data1[Column1],each Data2[Column2],(x,y)=>x&y)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.