Dynamic filter based on condition

[Derevon]

Hi everyone,

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?

Thank you

[v-piga-msft]

Hi @Derevon ,

To undersand your scenario better, please share your data sample and your desired output so that we could copy and test on it.

Best Regards,

Cherry