Forum Discussion

mespinosa's avatar
mespinosa
New Member
3 years ago

Using data created in PowerBi pivot in new calculated values table

I have created a pivot table in PowerBi. How can I create a new table that uses the data from the pivot table in calculated values? I also need it to be dynamically changing with slicers so that both...
Dataflow
Need Help
Tutorial Requests
  • miespino's avatar
    miespino
    Frequent Visitor
    3 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.