Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi I have the following table
Unit Reference | Property Attribute | Final Cost |
21428 | BATHROOM | 2493 |
21428 | FENCE-REAR | 597.1 |
21428 | BOUNDARY | 1869.6 |
21428 | BRICKWORK | 80 |
21428 | EXTDOOR2 | 1000 |
21428 | CHIMNEY | 2450 |
21428 | FENCE-FRNT | 344.75 |
21428 | COOKER | 0 |
21428 | DEC-EXT | 4432 |
21428 | EXTDOORS | 1200 |
21428 | ELECTRICAL | 300 |
21428 | F-FREEZER | 0 |
21428 | GATE | 120 |
21428 | HEATING | 3250 |
21428 | KITCHEN | 5879 |
21428 | LAND | 0 |
21428 | PATHWAYS | 8114.4 |
21428 | ROOFS | 13746 |
21428 | SMOKE | 255 |
21428 | SOFFITS | 1499.5 |
21428 | WINDOWS | 525 |
21428 | GARAGE | 3112 |
21428 | WFINISH | 2980.5 |
21428 | WSTRUCTURE | 90 |
In power query I would like to transpose it to look like this with the unit reference in the first column
Unit Reference | BATHROOM | FENCE-REAR | BOUNDARY | BRICKWORK | EXTDOOR2 | CHIMNEY | FENCE-FRNT | COOKER | DEC-EXT | EXTDOORS | ELECTRICAL | F-FREEZER | GATE | HEATING | KITCHEN | LAND | PATHWAYS | ROOFS | SMOKE | SOFFITS | WINDOWS | GARAGE | WFINISH | WSTRUCTURE |
21428 | 2493 | 597.1 | 1869.6 | 80 | 1000 | 2450 | 344.75 | 0 | 4432 | 1200 | 300 | 0 | 120 | 3250 | 5879 | 0 | 8114.4 | 13746 | 255 | 1499.5 | 525 | 3112 | 2980.5 | 90 |
The exampl below is for one unit there will be many untit references.
thank you
Richard
Solved! Go to Solution.
Hi,
You have to pivot your column Property attribute this way
and you get your result
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Great thnk you for your quick response 😀
Hi,
You have to pivot your column Property attribute this way
and you get your result
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Check out the July 2025 Power BI update to learn about new features.