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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors