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.
HIi,
I want to make the table below to this table
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7...
DATA1 DATA2 DATA3 DATA4 DATA5 DATA6
ANY IDEA HOW?
Solved! Go to Solution.
Yes, with the following code; replace Source with the name of your previous query step:
= Table.FromRows({Source[Column2]&Source[Column4]},Source[Column1]&Source[Column3])
Yes, with the following code; replace Source with the name of your previous query step:
= Table.FromRows({Source[Column2]&Source[Column4]},Source[Column1]&Source[Column3])
Thanks!
What do you suppose to do in this case ?
The code didn't work if I have null "headers" . I tried to create custom column and change null value to some different value like "1" but it didn't work
Hi, it is not.
It is different approach to solve my question.
The question in this topic is how can I use your code for transformation column with null values?
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 |
---|---|
105 | |
105 | |
87 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |