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.
Hi, is there a way to put 2 columns in the same data set under each other?
I explain, I have a data output that is like:
Columm1 | Columm2 | Columm3 | Columm4 |
DATA1,1 | DATA1,2 | DATA2,1 | DATA2,2 |
DATA1,3 | DATA1,4 | DATA2,3 | DATA2,4 |
DATA1,5 | DATA1,6 | DATA2,5 | DATA2,6 |
DATA1,7 | DATA1,8 | DATA2,7 | DATA2,8 |
DATA1,9 | DATA1,10 | DATAT2,9 | DATA2,10 |
And would like to pute Columm2 under Collum1 and Columm4 under Columm3
Columm1 | Columm3 |
DATA1,1 | DATA2,1 |
DATA1,3 | DATA2,3 |
DATA1,5 | DATA2,5 |
DATA1,7 | DATA2,7 |
DATA1,9 | DATAT2,9 |
DATA1,2 | DATA2,2 |
DATA1,4 | DATA2,4 |
DATA1,6 | DATA2,6 |
DATA1,8 | DATA2,8 |
DATA1,10 | DATA2,10 |
Thanks
Solved! Go to Solution.
@wolfy_ Please try this as a New Table
Test291Out = UNION(SELECTCOLUMNS(Test291UnPivot,"Column1",Test291UnPivot[Column1],"Column3",Test291UnPivot[Column3]) ,SELECTCOLUMNS(Test291UnPivot,"Column2",Test291UnPivot[Column2],"Column4",Test291UnPivot[Column4]))
Proud to be a PBI Community Champion
@wolfy_ Please try this as a New Table
Test291Out = UNION(SELECTCOLUMNS(Test291UnPivot,"Column1",Test291UnPivot[Column1],"Column3",Test291UnPivot[Column3]) ,SELECTCOLUMNS(Test291UnPivot,"Column2",Test291UnPivot[Column2],"Column4",Test291UnPivot[Column4]))
Proud to be a PBI Community Champion
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 |