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
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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!