Forum Discussion
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?
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.
3 Replies
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.
Thank you, and what is the reason you do not recommend today to before?
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 🙂
