Forum Discussion

kintela's avatar
kintela
Helper II
9 years ago

using NOW() in filters

Hi

 

I need to filter by records with date > NOW() but in the filters in the Report if I put NOW() in the calendar does not work

 

I have created a calculated column 

 

 

So all the records with tha date "FECHAPRES" before NOW() are out of time. To filter by this column. But I have several records withe FECHAPRES >NOW() so with the "No" value in this column

 

 

but in my report when I filter by "No" any of 35 records appear

 

 

Any idea please???

 

Regards

 

 

Need Help

6 Replies

    • kintela's avatar
      kintela
      Helper II
      9 years ago

      I have this records not out of time

       

       

      that is, FECHAPRES>NOW() but in the report when I apply this filter dissapear

       

      And this is the only one filter

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi kintela,

        Please check it returns null when the filter is "no" for the value level in your report? Based on your screenshot, it works fine, and I am unable to reproduce your scenario according your given information. Would you mind share your .pbix file for further analysis?

        Best Regards,
        Angelia

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    If you use Q&A in the webserver you can ask questions like "from today" and that will appear in your filters.  You can then override the rest of the visual properties manually. 

     

    No good for PBI Desktop though.