Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
n8schicht
Helper I
Helper I

Table transformation List.Distinct ?

 

Hello everybody, 

@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:

n8schicht_0-1616343592288.png

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

n8schicht_1-1616344559306.png

 

 

1 ACCEPTED SOLUTION
nvprasad
Solution Sage
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

 

View solution in original post

1 REPLY 1
nvprasad
Solution Sage
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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.