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 table which has data as below:
And I want to associate first value of comma separated string in Column1 to first value of comma separated string in Column2 for each Id. Number of values in comma separated strings in both the columns will have same number of values, but it may be 2-digit, 3-digit or any digit number.
Hence, the following is the result I want:
Any help would be appreciated.
Thanks in advance.
Solved! Go to Solution.
Sorry. i gave you an unnecessary lengthy code. Following custom column will also be sufficient
=Table.FromColumns( { Text.Split([Column1],","), Text.Split([Column2],",") } )
Hi,
Add this Custom Column using Query Editor. Then Expqand it to new rows
=Table.Transpose( Table.FromColumns( List.Zip( { Text.Split([Column1],","), Text.Split([Column2],",") } ) ) )
Please also see attached file's Query Editor with few rows from your sample data
Sorry. i gave you an unnecessary lengthy code. Following custom column will also be sufficient
=Table.FromColumns( { Text.Split([Column1],","), Text.Split([Column2],",") } )
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.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |