Filter Out Dates less than today on import

[Anonymous]

Hi all,

I am importing maintenace records into a report and it is literally a dump of data containing a maintenance end date.  I don't care about dates in the past and I thought I could setup a conditional column at the time of importing to just say something like if maint end date >= today(), 1, 0 and then just filter the list for the 1.

I can't seem to set that up in the way I thought, is there a way to do it at the initial import to just trim the data out I don't need?

ta

[NickolajJessen · Accepted solution]

Hmm, that's a good questions. At some point, there needs to be an evaluation of the data.
I usually do my import through SQL, where SQL can evaluate the data, before it's imported by doing: Date > '01-01-2020' to restrict import.
But when importing a CSV, i think the only evaluation happens in power query 🤷‍

[NickolajJessen]

Depends on how you are importing the data and from where

[Anonymous]

Just a CSV import from a filer location

[Anonymous]

I made a measue then slapped that in as a filter for the data that is being displayed.