Forum Discussion
Table transformation List.Distinct ?
Hello everybody,
Anonymous
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
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
1 Reply
- nvprasadSolution Sage
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