Forum Discussion

DaGemsta's avatar
DaGemsta
Helper I
2 years ago
Solved

Pivot multiple columns and sum values base on multiple columns in m query

Hi guys   This is hard to describe but I'll do my best! Delivery Date Truck Pot1Prod Pot1Out Pot2Prod Pot2Out Pot3Prod Pot3Out Pot4Prod Pot4Out Pot5Prod Pot5Out 19-Oct-23 TRU...
Need Help
Show and Tell
Tips and Tricks
DaGemsta's avatar
DaGemsta
Helper I
2 years ago

Hey Yolo 🙂

Wow that's a really clever solution thanks you!

Just one problem.. I'm working with a few thousand rows and on the "Pivoted Column" step it's hanging.

"= Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[Attribute.2]), "Attribute.2", "Value")"

I've left that step running for over half an hour but it still hasn't completed.

 

Any ideas how to unstick this step? It seems fine with less rows to work with.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DaGemsta 

If there is more data, the processing will be slow, and the amount of data can be appropriately reduced.

 

Best Regards!

Yolo Zhu

 

  • DaGemsta's avatar
    DaGemsta
    Helper I
    2 years ago

    Hi Yolo

     

    unfortunaetly even after leaving it for 2 hours it never completes 😞