Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Resolver I
Resolver I

Filtering the last months data in power bi report builder

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.




Super User
Super User



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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

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.



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?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors