Need help to create table

mervetitirinli , You need to unpivot the table 2 for that in power query and then use it

 

https://radacad.com/pivot-and-unpivot-with-power-bi

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Hi, mervetitirinli 

 

You can try the following methods.
Power Query-Transform-Transpose:

Result:

Is this the result you expect? What is the logic of the other table, can you explain?

 

Best Regards,

Community Support Team _Charlotte

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