Forum Discussion

abh1abh's avatar
abh1abh
Frequent Visitor
3 years ago
Solved

How to rewrite an sql code in power query M

Im not that good at power query, but im trying to learn it.    I have some knowledge from working with databases.    I want to rewrite this into power query's advanced editor: (SELECT Port_of_L...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    NewStep=Table.Pivot(#"Filtered Rows"[[Port_of_Loading],[Shipping_Line],[20DC]],{"MSC","COSCO","YANGMING“,”HAPAG","CMA-NAK","CMA-CGM"},"Shipping_Line","20DC",each List.Min(_)??0)

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

NewStep=Table.Pivot(#"Filtered Rows"[[Port_of_Loading],[Shipping_Line],[20DC]],{"MSC","COSCO","YANGMING“,”HAPAG","CMA-NAK","CMA-CGM"},"Shipping_Line","20DC",each List.Min(_)??0)

  • abh1abh's avatar
    abh1abh
    Frequent Visitor
    3 years ago

    Thank you so much!