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

rcb0325's avatar
rcb0325
Helper I
4 years ago

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:

 

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

  • rcb0325's avatar
    rcb0325
    Helper I
    4 years ago

    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? 

  • plimbacher's avatar
    plimbacher
    Frequent Visitor
    2 years ago

    Had the same issue.  Solution works perfect. Thanks!