Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
@v-yiruan-msft
You have helped me so well with this topic:
https://community.powerbi.com/t5/Desktop/Tabel-tansformation-need-help/m-p/1734060#M683562
that I wonder if you also have an idea here:
I have a second table:
first row -> Artikelnumber
second row -> Attribute Name
third row -> Attribute Value
I would like to build the following data structure from this data:
Article number; Attribute-Name_1; Attribute_Name_2; etc ..... depends dynamically on the number of attribute names, i.e. my target table gets wider and wider depending on the existing attribute names
Solved! Go to Solution.
Hi,
You can do this using pivot transformaiton in the Query editor.
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
Hi,
You can do this using pivot transformaiton in the Query editor.
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |