Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filter date until this month

Hi,   I have Leave Data from dynamics. So I have 2 types of leave, 1 is Leave Credit, and 1 is Annual Leave. the Leave Credit data is already loaded until the end of the year. Example: we have 2...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Already found the answer!

     

    = Table.SelectRows(#"Name of Previous Step", each [pafo_EstimatedEndDate] <= DateTime.LocalNow())

     Just want to share if someone needs it :)

     

    Thanks!

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Anonymous,

 

You may select "Custom Filter..." and do research into The Advanced Editor.

    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each Date.IsInPreviousNMonths([Date], 12) or Date.IsInCurrentMonth([Date]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    but if you use

    Date.IsInPreviousNMonths([Date], 12)

     It will be only take data for last year right?

     

    Example the data already from January 2017 - March 2018.

    Today month is February 2018, it will only take data from February 2017 - February 2018 right?

    What I need is the data from January 2017 - February 2018 (if the example today is february).