cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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 pivot table as an another table in Power BI, so that I can join the table with my base table. 

 

Cheers

Shruti 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Pivot table to be saved as another table

Hi @Shruti_Goyal94,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Support Team
Community Support Team

Re: Pivot table to be saved as another table

Hi @Shruti_Goyal94,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Pivot table to be saved as another table

@v-jiascu-msft

 

I want something like shown below:

 

Screenshot_1.pngDataScreenshot_2.pngOutput

Community Support Team
Community Support Team

Re: Pivot table to be saved as another table

Hi @Shruti_Goyal94,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Pivot table to be saved as another table

@v-jiascu-msft

 

Yes I ahve gotten the solution, thank you so much

 

Regards

Shruti