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
PascalT
Helper I
Helper I

[DAX] [HELP!!] Struggling with pivot tables...

Hi DAX experts

 

For a second time, i need your help 🙂

 

I've this table:

 

DAX1.PNG

 

I try to do a pivot table to get a Tabler with several columns (First name, Last name ... until ... sitecore Country) with three rows, one for each person.

 

So i select the Key column, go in Pivot table like that:

 

DAX2.PNG

 

But then, i get this table with error everywhere...

 

DAX3.PNG

 

The error is : 

 

DAX4.PNG

 

Arrggg...

 

I dont see where is my mistake...

 

Thank you for your help.

 

Pascal

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@PascalT

You need an additional column - like a unique index for each record

Seee my response here....

http://community.powerbi.com/t5/Desktop/Pivot-text-to-table/m-p/97264#M40976

 

Pivot Column Solved.png

 

Maybe @MarcelBeug can show us how to create this Index in the Query Editor if you don't have it in your data

View solution in original post

7 REPLIES 7
Sean
Community Champion
Community Champion

@PascalT

You need an additional column - like a unique index for each record

Seee my response here....

http://community.powerbi.com/t5/Desktop/Pivot-text-to-table/m-p/97264#M40976

 

Pivot Column Solved.png

 

Maybe @MarcelBeug can show us how to create this Index in the Query Editor if you don't have it in your data

MarcelBeug
Community Champion
Community Champion

Sure. A quick video as I need to get offline for the rest of the day (5:20 PM over here).

Specializing in Power Query Formula Language (M)
Sean
Community Champion
Community Champion

@PascalT 

You should not be getting the errors anymore once you add the Index as per @MarcelBeug's video! Smiley Happy

 

10:34 AM over here Smiley Happy

 

5:34 AM tomorrow March 11 @Phil_Seamark

That's right @Sean & @PascalT, it's March 11th here. 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

image1.PNG

 

@Phil_Seamark  you are on the Forums way too early! Smiley Very Happy

Hi @Sean It's raining pretty heavily here today, + I have a 2yo

 

http://www.metservice.com/maps-radar/rain-radar/wellington


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Hi all of you, expert in PowerBI.

Thank you very much, it worked!!!

 

I can now continu my duty and ask my new question soon 😉

 

Good end of week end to you.

 

Pascal

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.