Forum Discussion
Filter Expression for Report Builder
Hi rcb0325 ,
Do you want to filter the records in the table 'fact ProductionRouteView' which the value of the field [EndDateTime] is equal to the day before today? Please update the filter expression as below and check if the report can run successfully...
[EndDateTime] = DateAdd(DateInterval.Day, -1, Today())The below screenshots are testing results(I run it with Power BI Report Builder)...
Best Regards
Hi rcb0325 ,
Please update the filter expression circled in red as below:
| =DateAdd(DateInterval.Day, -1, Today()) |
You can find the details in the following official documentation.
Expression examples in Power BI Report Builder
If the above one is not working, please provide some sample data involved in paginated report and the error message when you run the report. Thank you.
Best Regards
Here is the error message when I try to execute the query, using the updated filter expression:
Below is some sample data from the executed query without the EndDateTime filter:
Hi rcb0325 ,
Do you want to filter the records in the table 'fact ProductionRouteView' which the value of the field [EndDateTime] is equal to the day before today? Please update the filter expression as below and check if the report can run successfully...
[EndDateTime] = DateAdd(DateInterval.Day, -1, Today())The below screenshots are testing results(I run it with Power BI Report Builder)...
Best Regards
That did it! thank you so much. May I ask why we it had to be done as a field filter and not a query filter?
