I have a filter that shows only rows older than 60 days compared to the last day of the current month. The code looks like this:
#"Filtered Rows" = Table.SelectRows(Source, each [Rec Date] < Date.AddDays(DateTime.Date(Date.EndOfMonth(DateTime.LocalNow())), -60)),
However, I would like to use a different comparison date depending on the current day of the month. On day 1-5 every month, I would like the last day of the previous month to be used as a comparison date, and for all other days, the last day of the current month.
How can I do this? Can it be done using the if function somehow?