M Code to limit Date

[Anonymous]

Hi All,

I want to limit a data set to have no departure date greater than last Sunday with Monday as the start of the week. The static value of the 26th works but i would like it dynamic so you don't to change each week.

= Table.SelectRows(#"Changed Type3", each [Departure Date] < #date(2021, 4, 26))

= Table.SelectRows(#"Changed Type3", each [Departure Date] <= dateDate.EndOfWeek(#datetimezone(Day.Sunday)Day.Monday)

Thanks

[Payeras_BI · Accepted solution]

Hi again @Anonymous ,

In case you work with future dates would be => "Less than Today and Not in This Week".

= Table.SelectRows(#"Changed Type3", each not Date.IsInCurrentWeek([Departure Date]) and [Departure Date] < DateTime.LocalNow())

[Payeras_BI]

Hi @Anonymous ,

Try with this:

= Table.SelectRows(#"Changed Type3", each not Date.IsInCurrentWeek([Departure Date]))