Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
@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
User | Count |
---|---|
57 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |