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 

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
      Community 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Please find the sample data and result snap

        red boxed details should be not displayed and green box details (upcoming lease expiry data) should be display

         

        hope i clear on my results

         

        Click here