Forum Discussion

rcb0325's avatar
rcb0325
Helper I
4 years ago
Solved

Filter Expression for Report Builder

Hello! I am trying to write a filter expression that tells the report to only look at the previous day. This is using a date column, and not a date table. I am having a very difficult time getting th...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

plimbacher's avatar
plimbacher
Frequent Visitor
2 years ago

Had the same issue.  Solution works perfect. Thanks!