Expression To Change Specific Date Based On Built In Date Filter

[kraamerica]

If the following:

= Table.SelectRows(#"Changed Type", each [BOOK_DT] = #date(2025, 3, 19) or Date.IsInPreviousNDays([BOOK_DT], 1))

I'm trying to change the specific date listed as the actual date 2025, 3, 19 to show today and previous day but I can't write this correctly. Searches turn up how to write it as if I only want to have the expression just showing as today's date. So it needs to be overwritten with this?: <= Date.From(DateTime.LocalNow())) but I keep getting an error.

OR is there a way to filter the query date filter editor to just show today and previous day?

Thanks in advance.

 

[johnny51981]

You can filter based on a date being today or yesterday, that would be

= Table.SelectRows(#"Changed Type", each ([BOOK_DT] = Date.From(DateTime.LocalNow()) or [BOOK_DT] = Date.AddDays(Date.From(DateTime.LocalNow()), -1)))

 

[kraamerica]

You can filter based on a date being today or yesterday, that would be

= Table.SelectRows(#"Changed Type", each ([BOOK_DT] = Date.From(DateTime.LocalNow()) or [BOOK_DT] = Date.AddDays(Date.From(DateTime.LocalNow()), -1)))

THANK YOU!