Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am trying to create a filter that will only show dates that are in or later than the current month. Someone helped me with a column measure to identify if the date is in or later than the current month, but it stops working once the date reaches 1st Oct (202210). I suspect it stops working because the date goes from "20229" to "202210", and an extra digit being added, but cant figure out how to fix.
I have attached a sample file. Example file.
Thanks in advance.
Solved! Go to Solution.
You can use
Current Month or Later = IF( 'Dates'[Date] >= DATE( YEAR( TODAY()), MONTH( TODAY()), 1), "Yes", "No")as the column definition
You can use
Current Month or Later = IF( 'Dates'[Date] >= DATE( YEAR( TODAY()), MONTH( TODAY()), 1), "Yes", "No")as the column definition
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 65 | |
| 44 | |
| 40 | |
| 29 | |
| 19 |
| User | Count |
|---|---|
| 200 | |
| 130 | |
| 102 | |
| 72 | |
| 55 |