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
Icon for Community Champion rankCommunity 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
Icon for Community Champion rankCommunity 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