Applying a Condition on creating a new table from existing table

Question

Hello PowerBI Community,&nbsp;I have a mock dataset: (Called TableA)&nbsp;Company NameProduct Type (Only 2 Types)1Q20 Qty1Q20 Profit2Q20 Qty2Q20 Profit....4Q22 Qty4Q22 Profit...A........................B........................B........................A.....................&nbsp;I would like to create a table as shown below:&nbsp;&nbsp;PeriodQtyProfit2020-01......2020-04...............This is the code I currently have for creating the table here:NewTable =&nbsp;UNION ( ROW ( "Period", "2020-01", "Qty" , SUM (TableA[1Q20 Qty]), "Profit" , SUM (TableA[1Q20 Profit]) ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ROW ( ....)&nbsp;I have 12 of such rows above to cover all 3 years. The problem I encounter would be that I need to separate the table according to the 2 different product types (A &amp; B). The best is this can be displayed in 1 table but creating 2 different tables is fine as well.&nbsp;Do advice if there is a simpler method to create the table.&nbsp;Thank you very much!

amitchandak · Accepted Answer

lwklwk98 , In DAX you will have code like this. One table with product type is a better option 
&nbsp;
In power query it is not going to be easy too
multiple unpivot you have to check
https://kohera.be/blog/power-bi/how-to-unpivot-twice/

Forum Discussion

Applying a Condition on creating a new table from existing table

2 Replies

Related content

Apply Conditional Formatting to All series

Want to apply Conditional Formatting on Matrix Visual

Conditional formatting not applied

Create conditional measure

Want to apply Conditional formatting on matrix visual

Company Name	Product Type (Only 2 Types)	1Q20 Qty	1Q20 Profit	2Q20 Qty	2Q20 Profit	....	4Q22 Qty	4Q22 Profit
...	A	...	...	...	...	...	...	...
...	B	...	...	...	...	...	...	...
...	B	...	...	...	...	...	...	...
...	A	...	...	...	...	...	...	...

Period	Qty	Profit
2020-01	...	...
2020-04	...	...
...	...	...