Forum Discussion
Pivoting distinct values from column into row
Hi 🙂 I have been battling this issue for a day now and could really use some support! I am not new to power query but I am no expert. My issue is this: I am pulling in data from an AP...
Reference your query three times.
a) on the first reference, remove columns Teams and Program.
b) on the second one, remove Program and unpivot Teams.
c) on the third one, remove Teams and unpivot Program.
d) Merge the first and the second one, expand Teams.1, Teams.2.
e) Merge the first and the third one, expand Program.1, Program.2.
Hi @ArmandoFranco - thanks for such a quick response!
I had considered something like this, my concern with that method is that the query is big and takes a while to update due to the amount of data from the API link, and so duplicating it 3 times would significantly slow down PBI /: - but should there be no other workarounds I might have to do something like this!
