Forum Discussion

Raph's avatar
Raph
Helper III
6 years ago
Solved

SelectRows under condition

Hello,

 

I would like to use this function :

 

SelectRows(#"Type modifié4", each [Artikelnummer] <> "4" or [Artikelnummer] <> "7" or [Artikelnummer] <> "12")

 

only when the date in column Date is after 30th september 2019 (30/09/2019)

 

Could you tell me how to proceed ?

 

Thank you very much.

 

Best regards

Raphaël

 

Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Raph 

    Try this

    Table.SelectRows(#"Added Custom", each not ( (  [Date] > #date(2019, 9, 30) ) and ( [Artikelnummer] = 4 or [Artikelnummer] = 7 or [Artikelnummer] = 12 ) ) )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Raph 

    Try this

    Table.SelectRows(#"Added Custom", each not ( (  [Date] > #date(2019, 9, 30) ) and ( [Artikelnummer] = 4 or [Artikelnummer] = 7 or [Artikelnummer] = 12 ) ) )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski