Forum Discussion
Using data created in PowerBi pivot in new calculated values table
Hi, I think the fields parameter will help with dynamic slicing but how can we get data resulting from a pivot table into the fields section to use for new calculatied measures or visualizations? For example if we wanted to create a table based on the data in the generated pivot table.
Hi mespinosa ,
You can try table functions such as summarize(), addcolumns(), values().
If you mean transpose tables, then you can use the union() function.
Please refer to the following document for more information.
Table manipulation functions (DAX) - DAX | Microsoft Learn
Transpose a table - Microsoft Power BI Community
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.