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.
@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
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 |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |