Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MP-iCONN
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.  

 

MPiCONN_0-1638987728003.png

 

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

 

Thank you for any help you can give.

 

Chad

 

3 REPLIES 3
GilbertQ
Super User
Super User

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





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.

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?





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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors