Forum Discussion

jbranch's avatar
jbranch
Frequent Visitor
11 months ago
Solved

Run a Paginated Report for Yesterday

I have been asked to set up a daily report for a member of staff that lists the number of calls made using each of our external phone numbers. I have this data present in my semantic model that I use...
Need Help
  • GilbertQ's avatar
    GilbertQ
    11 months ago

    Hi jbranch 

     

    Yes, this is possible and one of the easiest ways to do this is to create a date parameter for yesterday's date and then what you do is you create a filter where your parameter value is equal to the date value in your data. That should then filter out all the data to only show the rows for yesterday's date.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
11 months ago

Hi jbranch 

 

Yes, this is possible and one of the easiest ways to do this is to create a date parameter for yesterday's date and then what you do is you create a filter where your parameter value is equal to the date value in your data. That should then filter out all the data to only show the rows for yesterday's date.

  • jbranch's avatar
    jbranch
    Frequent Visitor
    11 months ago

    Hi GilbertQ

     

    Thank you for your response. I assume this is something that must be done in the Report Builder, because there doesn't seem to be any functionality like this in the service (which seems bafflingly lacking, even for a preview). I tried to get it working in the way described but for some reason it wouldn't return any data for yesterday, but would for all previous days (not really sure why). In the end I ended up putting the data I needed into Power BI Desktop and used a slicer to filter it and copied the DAX from the query view into the Report Builder, which has worked.

     

    Thanks again for the pointers.