Forum Discussion
Solved
Need help with a line of M Code
Hello. I need a line of M Code that will NOT filter the following [VOIDSTTS] of 0; [VOIDSTTS] of 1 where [VOIDDATE] > AsOfDate. Right now, the AsOfDate is 9/6/2025. Here are what the two columns l...
If [VOIDSTTS] are of Text data type, and [VOIDDATE] are Date, you can do this by adding a step in M,
Table.SelectRows(#"laststep",
each[VOIDSTTS] = "0" or ([VOIDSTTS] = "1" and [VOIDDATE] > #date(2025, 9, 6))
)
rmcgrath Try the following:
Table.SelectRows(#"Changed Type", each ([#"[VOIDSTTS]"] = 0 or [#"[VOIDDATE]"] > #date(2025, 9, 6) ))