Solved: Re: M Code to limit Date

Anonymous · ‎04-29-2021

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 · ‎04-29-2021

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())

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

View solution in original post

Payeras_BI · ‎04-29-2021

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())

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

Payeras_BI · ‎04-29-2021

Hi @Anonymous ,

Try with this:

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

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain