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

[trevb]

Okay so my data looks like this:

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...

Looking at each of these the error is

[trevb]

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]

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

[trevb]

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 🙂