Forum Discussion

Derevon's avatar
Derevon
New Member
7 years ago

Dynamic filter based on condition

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

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    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