Forum Discussion

amyod's avatar
amyod
Frequent Visitor
5 years ago
Solved

Excluding future dates from power query

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 af...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Hi amyod 

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

     

amyod's avatar
amyod
Frequent Visitor
5 years ago

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

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    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