Dataflow Calendar

[Unknowncharacte]

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?

[ray_aramburo · Accepted solution]

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]

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

[ray_aramburo]

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 🙂