Calculate column by add column values of a row for defines values of other columns of the same row

[Maristella]

Table organized as per below screenshot.

I want to create three colums: "Total HFO Cons" , "Total LSFO Cons", "Total MGO Cons" with values

"Total HFO/LSFO/MGO Cons" =  'Consumption (Laden Days Anchorage/Idle)' (IF Fuel Type (Laden Days Anchorage/Idle) is HFO/LSFO/MGO respectively) + 'Consumption (Laden Days Port Operations)' (IF Fuel Type (Laden Days Port Operations) is HFO/LSFO/MGO respectively) 

What formula/query would bring the desired result as described on the problem above? 

[v-yetao1-msft]

Hi @Maristella 

Please correct me if I wrongly understood your problem .

For colums "Total HFO Cons" , if Fuel Type (Laden Days Anchorage/Idle) is same with Fuel Type (Laden Days Port Operations) , then result the sum of Consumption (Laden Days Anchorage/Idle) and Consumption (Laden Days Port Operations) ? For example , if Fuel Type (Laden Days Anchorage/Idle) is HFO , Fuel Type (Laden Days Port Operations) is HFO , then return 3+4.5=7.5 , right ? If Fuel Type (Laden Days Anchorage/Idle) and Fuel Type (Laden Days Port Operations) are different value , then return null ?

Best Regards,
Community Support Team _ Ailsa Tao

[amitchandak]

@Maristella , Based on what I got, Power Query Pivot column should help you

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

Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12