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
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?
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 🙂
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Click here to read more about the December 2021 Updates!