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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks Vijay. It works fine.. 

Spoiler
 

May i know how could i able to use the existing table as a source.

 

Also, how could i plot the month as a bar chart with Jan, Feb.. as month in correct order.. 

 

Thanks again.

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    What is your source? Are you using Power BI Desktop to plot the graph?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      yes.. im using the sharepoint list as my data source.

      • Vijay_A_Verma's avatar
        Vijay_A_Verma
        Icon for Most Valuable Professional rankMost 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.