Forum Discussion
Custom Date filter in Advanced Editor
I need a custom date filter that includes anything from the past 60 days. I don't see in "Filtered Columns" that this is an option. I have put a custom SQL statement into the Advanced Editor, but I...
Have you tried with the Date.IsInPreviousNDays M function? /sample code/ #"Filtered Rows" = Table.SelectRows(#"Changed Type", each Date.IsInPreviousNDays([Date], 60))
Thanks, Anonymous. I will give that a shot. I did not know the proper syntax to make the change. I tried something similar to the SQL code, but that was not correct.