Forum Discussion
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...
Hi Raph
Try thisTable.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.
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
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
