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 m...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    You can use

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

    as the column definition

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You can use

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

as the column definition