Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

if else with or and is not working

Hi,    I have two columns        1) Labour class        2) HRMS i am using the following m query code attached in picture but it is not giving correct result. First 3 conditions are giving corre...
Need Help
Show and Tell
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

= List.Skip({"Foreman","Senior Foreman","Supervisor"},each not Text.StartsWith([HRMS],_,Comparer.OrdinalIgnoreCase)){0}? ??if List.Contains({"1AA","1bb"},[labour Calss]) then "Junior Staff" else null)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi wdx223_Daniel  it is giving error on if as i have attached SS.


  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    3 years ago

    = List.Skip({"Foreman","Senior Foreman","Supervisor"},each not Text.StartsWith([HRMS],_,Comparer.OrdinalIgnoreCase)){0}? ??(if List.Contains({"1AA","1bb"},[labour Calss]) then "Junior Staff" else null))