Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sort column by today's date

Hi    I wish to filter Lease end date column by today's date which is available in table in query editor   Please help  
Need Help
Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Anonymous ,

= Table.SelectRows(#"Changed Type1", each [date] = Date.From(DateTime.LocalNow()))

You don't need to create a column.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Can I have a working file for my reference
  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Anonymous ,

    Add this in the Advanced Editor.  
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

     

     

     

     

    Table.SelectRows equals filter
    #"Changed Type1", is my previous step

    each [date] date is my column name

     

    Date.From(DateTime.LocalNow())) gets today's date, and formats it as a date

     

     

    • Nathaniel_C's avatar
      Nathaniel_C
      Community Champion
      6 years ago

      Anonymous ,

      Trade you for a kudo or two:smileywink:

       

      date 

       

      Above is the PBIX

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        it's filter by today, i wish to display upcoming lease end date as weel in the table