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

     

     

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