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 after today's date) and I am lost about the code. Any help would be greatly appreciated!

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

     

3 Replies

  • 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

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    Hi amyod 

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