Power Query - Multiply by % if Descriptions column contains certain phrases

Question

Hi&nbsp;&nbsp;I am looking for a calc that multiplies my cost column by 3% if my description column contains one of the below phrases, if it does not then it does not multiply.&nbsp;&nbsp;Labour&nbsp;Subcontract&nbsp;Plant&nbsp;Materials&nbsp;any help much appreciated&nbsp;

oliverscheurich · Answer

Adean7&nbsp;You can try the attached file.

sergeibaklan · Answer

Adean7&nbsp;
As variant
let
    Source = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
    words = {"plant", "materials", "subcontract", "labour" },
    adjustCost = Table.AddColumn(
        Source,
        "new cost",
        each
            if List.ContainsAny( Text.Split([description], " "), words )
            then [cost]
            else [cost]*1.03,
    type number )
in
    adjustCost

Forum Discussion

Power Query - Multiply by % if Descriptions column contains certain phrases

2 Replies

Resources