Filter dates in table to show dates older than 30 days

[shaunguyver]

I have a table with dates, and I want to filter the table to only show values where the date is older than 30 days (as of today). How do I do this?

[DoubleJ · Accepted solution]

Hi

You can add a calculated column to your dates table with a formula that checks whether the day falls within the last 30 days. You can then filter your visuals with this column.

Last30Days = 
IF(
    DATEDIFF(Dates[Date],TODAY(),DAY) <=30,
    TRUE(),
    FALSE())

Hope this helps (if so please give a kudo)
JJ

[shaunguyver]

Thanks for the suggestion - I've tried to do this, but when I input the formula I get the following error message:

"Expression error: The name 'IF' wasn't recognized. Make sure it's spelled correctly."

Any idea why? I can't seem to find another way of doing this

[Ashish_Mathur]

Hi,

The formula suggested is a measure.  Go to Modelling > New Measure.  You are writing that formula in the Query Editor.