Forum Discussion

Unknowncharacte's avatar
Unknowncharacte
Helper III
2 years ago
Solved

Dataflow Calendar

Hi,    I have imported a calendar table from dataflows, the calendar goes up to year 2028, how do I filter it in Power Query to show dates only up to current date, not into the future?
Need Help
Tutorial Requests
  • ray_aramburo's avatar
    ray_aramburo
    2 years ago

    Select the date column, click on the right corner to filter it and choose the "Before" type filter and then input a specific date. If you strictly want only dates from today and before (which I don't recommend) you'll need to add a custom column that gets today's date (Date.From(DateTime.LocalNow())) and then create a conditional flag column that compares the date column against today (if date <= today column then 1 else 0). Use then the flag column to remove the 0s. 

Unknowncharacte's avatar
Unknowncharacte
Helper III
2 years ago

Thank you, and what is the reason you do not recommend today to before?

ray_aramburo's avatar
ray_aramburo
Super User
2 years ago

It's great that you are removing dates, since 2028 is still far away- Strictly using today and before limits you advanced time-intelligence analysis. For example, if you want to do forecasting, parallel periods, what if scenarios, etc. Filtering from today to before is understandable in a transactional table but not on a Calendar/dimensional table. I would just keep from the end of 2024 and before. Just my thoughts 🙂