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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-lili6-msft 

       

      Did you got the file 

      have you understood what i am looking for?

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

        hi, Anonymous 

        I am sorry that I did not notice this reply yesterday

        This item might not exist or is no longer available

        Please upload again.

         

        Regards,

        Lin