Change DAX measure into Power Query Editor Custom Column

Dear Ashish_Mathur ,

Thank for your attention.

Some operations have incorrectly input the data into system. Supposedly in one consol number, there is only have one brand in Consignee/Consignor. Like C002 and C003, this is correct input.

After we have the discussion, we come out some filter as below:
i.) if only one brand in consignee or consignor, prioritise Consignee. (C001)

ii.) if only one brand in consignee, and more than one brand in consignor, prioritise Consignee. (C002)
iii.) if only one brand in consignor, and more than one brand in consignee, prioritise Consignor. (C003)

iv) both of it having more than one brand, stated "MIX" (c004)

v.) if there have null value in consignee, but consignor have one brand, prioritise Consignor (Same if consignor have null value) 

vi.) if consignee/consignor have null value but also  one brand, like C009 and C010. We will prioritise this particular column.  

So at the end, we have captured Consignee/Consignor (which is correct input) and take action on those MIX/Blank consol number. 

I checked on this calculate column, all result had return correctly. But I would like to have some help to convert this into Power Query. 

Hope you can provide some help on it. Greatly appreciate!