Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get Column Table Summary from Same Column Header Name

Hello,   Good day! Pls your support to assist how can i get the summary from table column header name to another table row name value.   This should be my result table. Month Total Jan T...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use this link to connect to Sharepoint list - https://docs.microsoft.com/en-us/power-query/connectors/sharepointlist 

    In the last step, select Transform which will take you to the PQ. Here, Home - Advanced Editor - Copy the 2nd line which starts with Source and paste into a notepad

    Now remove everything from advanced editor.

    Copy my code there.

    Replace source line from notepad.

    Now OK.

    #"Changed Type", you will need to remove as it contains only Jan to Mar  and do your own Changed Type in the Power Query after Source step.

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Use this link to connect to Sharepoint list - https://docs.microsoft.com/en-us/power-query/connectors/sharepointlist 

In the last step, select Transform which will take you to the PQ. Here, Home - Advanced Editor - Copy the 2nd line which starts with Source and paste into a notepad

Now remove everything from advanced editor.

Copy my code there.

Replace source line from notepad.

Now OK.

#"Changed Type", you will need to remove as it contains only Jan to Mar  and do your own Changed Type in the Power Query after Source step.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Great. Thanks for your support.