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?
Go to Solution.
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.
Hope this helps (if so please give a kudo)JJ
View solution in original post
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
The formula suggested is a measure. Go to Modelling > New Measure. You are writing that formula in the Query Editor.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.