How to limit date to most recent day?

[ERing]

I have a table with a Job_Created_On date. The issue I'm facing is the data contains Job_Created_On dates many years into the future. This is not logically possible as the most recent date for a Job_Created_On is TODAY.

I'm trying to improve my report performance so I want to remove any records from my table with a Job_Created_On date that is in the future. I want to limit the table to Job_Created_On dates that are TODAY or in the past.

How can I do this?

[Expiscornovus · Accepted solution]

Hi @ERing,

You can use a SelectRows which compares it with the DateTime LocalNow.

Below is an example

1. The below line is added as a new step via the advanced editor.

#"Filter Future Dates" = Table.SelectRows(#"Changed Type", each [JOB_CREATEDON] <= DateTime.LocalNow())

2. Below is the test data before that new step

3. Below is the test data after the new step (all the future dates are filtered)

[Uzi2019 · Accepted solution]

Hi @ERing 

Try below video for better understanding
https://www.youtube.com/watch?v=cepZFDUwLQM

https://www.youtube.com/watch?v=rDtMe1exW5g

https://www.youtube.com/watch?v=7jJTEVUtSKI

You can try any technique to get the desired result. 
I would suggest simple technique is 3rd video. 

I hope I answered your question!

[Expiscornovus · Accepted solution]

Hi @ERing,

You can use a SelectRows which compares it with the DateTime LocalNow.

Below is an example

1. The below line is added as a new step via the advanced editor.

#"Filter Future Dates" = Table.SelectRows(#"Changed Type", each [JOB_CREATEDON] <= DateTime.LocalNow())

2. Below is the test data before that new step

3. Below is the test data after the new step (all the future dates are filtered)