Excluding future dates from power query

[amyod]

I'm a new user and am working with a date set that contains future dates (e.g. through December 2021). I want to exclude data points associated with future dates from my PowerQuery (e.g. any dates after today's date) and I am lost about the code. Any help would be greatly appreciated!

[amyod]

Thank you! And will that setting refresh automatically with future dataset refreshes?

[aj1973]

Welcome

What is applied in Power Query is a reflection to what is happening in the Service. So if you don't want to see future dates in Power Query then you won't see it in Service

[aj1973 · Accepted solution]

Hi @amyod 

In Power Query you can add a setp where you can filter the column date Before Today