Forum Discussion
lwklwk98
Helper I
Helper IApplying a Condition on creating a new table from existing table
Hello PowerBI Community, I have a mock dataset: (Called TableA) Company Name Product Type (Only 2 Types) 1Q20 Qty 1Q20 Profit 2Q20 Qty 2Q20 Profit .... 4Q22 Qty 4Q22 Profit ... ...
lwklwk98 , In DAX you will have code like this. One table with product type is a better option
In power query it is not going to be easy too
multiple unpivot you have to check
amitchandak
Super User
Super Userlwklwk98 , In DAX you will have code like this. One table with product type is a better option
In power query it is not going to be easy too
multiple unpivot you have to check
lwklwk98I un-pivoted my data as you mentioned and I realized that it might be better to do that instead.
Even though the cleaning process of duplicating the original table and removing unnecessary columns can be tedious, it allows me to leave a proper trace of my methods in the PowerQuery instead of a long line of hard codes.
Thanks amitchandak