Forum Discussion

kintela's avatar
kintela
Icon for Helper II rankHelper 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 th...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft 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

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

    Hi kintela，

    I download your file and extract it, but I don't fine .pbix file. Do you mind download again?

     

    >>I don't understand what are you saying "check it returns null when the filter is "no" for the value level in your report"

    I mean if you add other filter, which laed to the report don't return any value when you click No.

    Best Regards,
    Angelia