Forum Discussion

Andrew415's avatar
Andrew415
Frequent Visitor
1 year ago
Solved

Pivoting Multiple Columns More Efficiently

Hi, I am trying to find a more efficient way to multiple pivot columns in Power Query from a shipping report. I'm currently selecting each pair of columns (description and adjacent amount), pivoting ...
Need Help
Andrew415's avatar
Andrew415
Frequent Visitor
1 year ago

Would it be possible to list the measure here as text? I'll give it a go and see if it might help. The blank columns wouldn't need to be part of the visual

Irwan's avatar
Irwan
Super User
1 year ago

hello Andrew415 

 

i am not sure why you want it as text but perhaps it is possible.

you can tweak the DAX however you want to match up your requirement including the blank column.

 

otherwise, try using SundarRaj 's solution. it surely gives your broader insight of your case.

 

Thank you.