none
M- Code for Does not begin with RRS feed

  • Question

  • Hi All,

    I have a column "Cost element" and I want to apply 3 filter in it like :-

    Cost element does not begin with 3, 4 or 9. than How to apply all 3 filters at once ?

    Regards,

    Rajender


    Rajender

    Monday, March 11, 2019 9:11 PM

Answers

  • You could try this:
    Table.SelectRows(#"Your Table", each not List.Contains( {"3", "4"," 9"}, Text.Start([Cost element],1) ) )

    • Edited by anthony34 Monday, March 11, 2019 10:42 PM
    • Proposed as answer by Colin Banfield Monday, March 11, 2019 11:02 PM
    • Marked as answer by AskQuery1984 Tuesday, March 12, 2019 5:54 PM
    Monday, March 11, 2019 10:33 PM

All replies

  • You could try this:
    Table.SelectRows(#"Your Table", each not List.Contains( {"3", "4"," 9"}, Text.Start([Cost element],1) ) )

    • Edited by anthony34 Monday, March 11, 2019 10:42 PM
    • Proposed as answer by Colin Banfield Monday, March 11, 2019 11:02 PM
    • Marked as answer by AskQuery1984 Tuesday, March 12, 2019 5:54 PM
    Monday, March 11, 2019 10:33 PM
  • Hi Anthony/Colin,

    Thanks a lot for your help.


    Rajender

    Tuesday, March 12, 2019 5:55 PM