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!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Up, hoping someone can help

Anonymous's avatar
Anonymous
Not applicable
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!