Forum Discussion
StuartSmith
Power Participant
4 years agoOnly display current month or later {Part II} (example file attached)
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.
You can use
Current Month or Later = IF( 'Dates'[Date] >= DATE( YEAR( TODAY()), MONTH( TODAY()), 1), "Yes", "No")as the column definition
1 Reply
- johnt75
Super User
You can use
Current Month or Later = IF( 'Dates'[Date] >= DATE( YEAR( TODAY()), MONTH( TODAY()), 1), "Yes", "No")as the column definition