MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
Power Query dynamic previous months filter
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…
www.mrexcel.com
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?
Code
= Table.SelectRows(#"Sorted Rows", each Date.IsInPreviousMonth([Remedy Date Due]))Cheers Cobber.
