Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Create a new table from another table with different filters

Hello community, could you help me solve this problem?

I want to create a new table by copying the information from another table as follows:

4 Replies

  • Hii Syndicate_Admin 

    Try this, 
    In power Bi, Go to transformdata and select the table. Right-click to duplicate the table. In the table, choose the Tipo and Usarini columns, and in the above transfrom pane, select the pivot column option to pivot the table to get the solution.


     

     

    Did I answer your question?

    Mark my post as a solution, this will help others...!

    Hit the kudo also,

    Thank you.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator

      Thank you very much an additional query appears to me as follows, there is some way for the assignee and requester data to appear in a single row and not two as shown.

      • Syndicate_Admin's avatar
        Syndicate_Admin
        Icon for Administrator rankAdministrator

        An additional query appears to me as follows, there is some way for the assignee and requester data to appear in a single row and not two as shown.