Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

M Code to limit Date

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

Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

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

     

     

2 Replies

  • Payeras_BI's avatar
    Payeras_BI
    Solution Sage
    5 years ago

    Hi Anonymous ,

    Try with this:

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

     

  • Payeras_BI's avatar
    Payeras_BI
    Solution Sage
    5 years ago

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