Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
Solved! Go to Solution.
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! |
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! |