Forum Discussion

pigsinblankets's avatar
pigsinblankets
Icon for Helper II rankHelper II
2 years ago
Solved

Filter a visual on or before today's date

Good Afternoon,    Is there an easy way using the filters pane to filter visuals on or before today's date?    I can't seem to see this as an option which seems a bit odd unless I'm missing it!  ...
General Comment
Need Help
Show and Tell
Tips and Tricks
mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
2 years ago

Hi pigsinblankets 

 

If you have a calendar table, you can create an offset column which returns -1 if it's before today's date or 0 otherwise. Then, you can use filter pane to filter by <0 values

Offset = IF('Calendar'[Dates]<=TODAY(),-1,0)
  • pigsinblankets's avatar
    pigsinblankets
    Icon for Helper II rankHelper II
    2 years ago

    Ahh thank you mlsx4 ðŸ™‚