Forum Discussion
Solved
Unpivot columns while connected with Direct Query
Hi all, Is there a way to unpivot columns in power query while the data connected is using direct query? I have seen an example (powerbi - Is it possible to unpivot in Power BI using DAX? -...
Here's a simpler example.
Do this:
to get this:
Maybe try grouping by the ID column and take the maximum over the others.
Sorry, I am not sure what you mean
Here's a simpler example.
Do this:
to get this: