Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |