Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @Raph
Try this
Table.SelectRows(#"Added Custom", each not ( ( [Date] > #date(2019, 9, 30) ) and ( [Artikelnummer] = 4 or [Artikelnummer] = 7 or [Artikelnummer] = 12 ) ) )
Hi @Raph
Try this
Table.SelectRows(#"Added Custom", each not ( ( [Date] > #date(2019, 9, 30) ) and ( [Artikelnummer] = 4 or [Artikelnummer] = 7 or [Artikelnummer] = 12 ) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.