Forum Discussion

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
4 years ago
Solved

Only 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

  • You can use

    Current Month or Later = IF( 'Dates'[Date] >= DATE( YEAR( TODAY()), MONTH( TODAY()), 1), "Yes", "No")

    as the column definition