Hi all, how can I create a dynamic filter for 'previous months' but excluding last month, ie if it's currently October I want to filter for August and all previous months. Must be dynamic so that in November it filters for September and all previous months.
Is it possible to change the below code to suit?
Thanks in advance.
Is it possible to change the below code to suit?
Bash:
= Table.SelectRows(#"Sorted Rows", each Date.IsInPreviousMonth([Remedy Date Due]))
Thanks in advance.