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
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi, Anonymous 

If Today's Date2 will be updated every day?

If so, create a conditional custom column that if Lease End date column is after Today's Date2, then 1 else 2.

Then you could filter this custom column which is 1.

 

Or use this formula to create a custom column

if [#"Lease End date -Copy"]>=Date.From(DateTime.LocalNow()) then 1 else 2

Then filter it by the same logic.

here is sample pbix file, please try it.

 

 

Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-lili6-msft 

 

i got the nearly answer of my query but when i tried to put condiationl formatting it's showing data from all quarters since 2019 to next expiring dates, please see the snap

 

 

 

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi, Anonymous 

    Could you please share the sample pbix file for us have a test? For it's showing data from all quarters since 2019, there should be something wrong in other.

     

    Regards,

    Lin