Create a new table from another table with different filters

[Syndicate_Admin]

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:

[Vallirajap]

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]

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]

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.

[v-jianpeng-msft]

Hi, @Syndicate_Admin 

I have tested the data you provided in the case, and the test results are the same as those shown in the Vallirajap user. The test results are as follows:

At the same time, if the Ticket id has more than four items, the pivot will fail as shown in the following figure:

We must provide a unique value for each column corresponding to ticket id instead of multiple values. If you can provide sample data that does not contain privacy or describe your pivot operation process in detail, I will further analyze the reasons for your additional queries.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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