cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trevb
Resolver I
Resolver I

Totally unable to pivot this using PowerQuery and I am not sure why

 

Okay so my data looks like this:

 

Capture.PNG

 

And it goes down a long way.  What I want to do is to pivot this table based on the FinancialYearStart column. so that I get something that looks like

 

ProjectCode   2011  2012   2013  .......

Code              sum   sum    sum .......

 

Now this should be a classic but it just fails giving me this...

 

Capture1.PNG

Looking at each of these the error is

 

 

 

 

 

3 REPLIES 3
trevb
Resolver I
Resolver I

 

Capture2.PNG

 

I have absolutely no idea why this is.  I've tried using a replace to ensure any nulls are not nulls but this still happens.  I really need this but just cannot get it to work.

 

Anyone got any ideas?

itchyeyeballs
Impactful Individual
Impactful Individual

Is PBI automatically adding a convert values row to your query? its caught me out with that before. 

Turned out that an earlier step in the query that generated the source was adding an issue into the table.  Using a try otherwise on that eliminated the dodgy row/rows and the pivot worked 🙂

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!