Filtering the last months data in power bi report builder

[MP-iCONN]

I am trying to find the best way to filter on the Posted Date field and just return the last months values based on the Posted Date field.  

I did some basic searches but couldn't find a good way to do it.

Thank you for any help you can give.

Chad

[GilbertQ]

Hi @MP-iCONN 

What you would need to do and I would highly recommend is to create a date table. Then in this date table you could use a filter from the date table to filter to only show the last months data?

Here is a blog post with more details: Power BI Date or Calendar Table Best Method: DAX or Power Query? - RADACAD

[MP-iCONN]

I know how to do all of this in Power BI desktop and was successful with creating this report and dataset in that.  The reason I am doing this in Report Builder is because I can get it to subscribe and send me .csv files which can't be done with my subscription to Power Bi Premium User (which is sad they don't allow that, only PDF and PPTX).  Not very easy to figure out how to filter though in report builder so I am sure I am missing something.  Thank you.

[GilbertQ]

Hi @MP-iCONN 

You could do that in your Power BI Dataset, and then connect Report Builder to this same dataset and then in your date table, you could use the filters at the top of Paginated Reports and filter it there?