March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I have a brainbuster (for me)
I have a table which I want to Pivot. All content is Text.
I would like to Pivot the table to get the following result:
This presents me with the following problems:
1) Pivot wont work because I have multiple rows with same EmplID and Code.
2) To solve that I thought of grouping, summerizing code 1000 and summerize code 2000. but that doesn't work because its is Text.
3) Converting Text to Numeric works only for the 1000 and 2000 code, which is all I need, but the other codes will present an error.
I think it I need multiple steps to solve this?
Split the Content column? (how?)
Any thoughts?
Solved! Go to Solution.
Hi @PeterJansen2,
3) Converting Text to Numeric works only for the 1000 and 2000 code, which is all I need, but the other codes will present an error.
If the other codes is not needed/necessary, you can replace the error values with null or 0(or any other values you want to show) after Converting Text to Numeric. Then you should be able use the Pivot option get your expected result.
Final result:
Regards
Hi @PeterJansen2,
3) Converting Text to Numeric works only for the 1000 and 2000 code, which is all I need, but the other codes will present an error.
If the other codes is not needed/necessary, you can replace the error values with null or 0(or any other values you want to show) after Converting Text to Numeric. Then you should be able use the Pivot option get your expected result.
Final result:
Regards
Thanks for your reply.
As far as I know, a visual won't do the trick.
I need the pivotted data it in my tables, to do some calculations/measures etc with it.
@PeterJansen2 Take look at this link it might help for you
http://community.powerbi.com/t5/Desktop/Table-transformation-pivot-unpivot/m-p/231829#M103296
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
123 | |
85 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |