Subtraction based on if formula to create a new column Heading

[Anonymous]

Hi Experts

See link to sample data...

Ref to table Logistics in sample file and column New_Reporting_Headings - See 4 rows from bottom i have Total Logistics - I want to create this header based on the following 

(Inbound Freight + Duty + Warehousing - Fixed + Warehousing - Variable +SC&L People + outbound Freight) using the if formula??

https://www.dropbox.com/s/tbjnpv2wgiky3wc/PLP_Test.pbix?dl=0 

[amitchandak]

@Anonymous , are you looking Dynamic Title ?
https://www.youtube.com/watch?v=TYLKDPcvgK8
https://www.blue-granite.com/blog/create-a-dynamic-title-in-power-bi-updated

[Anonymous · Accepted solution]

solved it

New_Reporting_Headers =

IF( Logistics_[GrpId] = "a3", "External Sales",

IF( Logistics_[GrpId] IN { "a7", "a8" }, "Inbound Freight",

IF( Logistics_[GrpId] IN { "b2", "b3", "b4" }, "Duty",

IF(Logistics_[GrpId] IN { "i5", "i6" }, "Warehousing - Fixed",

IF(Logistics_[GrpId] IN { "i7", "j1" }, "Warehousing - Variable",

IF(Logistics_[GrpId] IN { "i1", "i2", "i3", "i4" }, "SC&L People",

IF(Logistics_[GrpId] IN { "i8", "i9", "j2", "j3" }, "Outbound Freight",

if(Logistics_[Reporting_Headers] IN { "a7", "a8", "b2", "b3", "b4", "i5", "i6", "i7", "j1", "i1", "i2", "i3", "i4", "i8", "i9", "j2", "j3" }, "Total Logistics",

Logistics_[Reporting_Headers]))))))))

[Anonymous]

Hi Amit - No just to amend the if formula to Total Logistics.... the same way i have combined two headings to give Inbound Freight