Forum Discussion

n8schicht's avatar
n8schicht
Helper I
5 years ago
Solved

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

  • nvprasad's avatar
    nvprasad
    Solution 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