Solved: How To Exclude Rows Using Date Filter With Between...

Anonymous · ‎05-18-2021

Hello Team,

This might be a simple for you experts, but I am stuck.

I have created a power query filter on a date column.

=Table.SelectRows(#"PrevStep", each [Clearing Date] >= #date(2020, 2, 1) and [Clearing Date] <= #date(2020, 12, 31))

My requirement is not to keep these rows. Can anyone help me with this ?

Thank You in advance.

CNENFRNL · ‎05-19-2021

One step away,

= Table.SelectRows(#"PrevStep", each not ( [Clearing Date] >= #date(2020, 2, 1) and [Clearing Date] <= #date(2020, 12, 31)))

or

=Table.SelectRows(#"PrevStep", each [Clearing Date] < #date(2020, 2, 1) or [Clearing Date] > #date(2020, 12, 31))

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

Anonymous · ‎05-19-2021

Thank You @CNENFRNL.

CNENFRNL · ‎05-19-2021

One step away,

= Table.SelectRows(#"PrevStep", each not ( [Clearing Date] >= #date(2020, 2, 1) and [Clearing Date] <= #date(2020, 12, 31)))

or

=Table.SelectRows(#"PrevStep", each [Clearing Date] < #date(2020, 2, 1) or [Clearing Date] > #date(2020, 12, 31))

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!