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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi conniedevina,

    could you please share the workbook :)

    Thank you in advance!

     

    Best Regards,

    Anastasiia Lagunova

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Anonymous,

       

      Please check this link for the workbook and data source (Excel).

       

      Thanks,
      Regards,
      Connie