Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Pivot table to be saved as another table

Hi all,   Answer to this query is really important for me.    I have a table with certain variables and I want to create a pivot table on that similar to excel. And I want to save this data of pi...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    Please share your file or a dummy sample. We need to do it with DAX or Power Query. So we can't talk about it without data.

    It could be something like this:

    Pivot_table_to_be_saved_as_another_table

     

    Best Regards,

    Dale

Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-jiascu-msft

 

I want something like shown below:

 

DataOutput

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Seems you have gotten the solution. The formula could be:

Table = SUMMARIZE('Table1', 
            Table1[Col2],
            Table1[Col1], 
            Table1[Col4],
            "Sum of Col3", sum(Table1[Col3]))

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    v-jiascu-msft

     

    Yes I ahve gotten the solution, thank you so much

     

    Regards

    Shruti