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.

Frequent Visitor

Filter dates by the most recent July and August

I need to create 3 filters;


1. Filter by the most recent July date range (01 July to 31 July 2022)

2. Filter by the most recent August date range (01 August to 31 August 2022)

2. Filter by the most recent July to August date range (01 July to 31 August 2022)


The issues is that it needs to be the most recent months. So when the refresh date is 01 August 2023, July 2023 becomes the July month that is filtered, and if the refresh date is November 2023, then July 2023 and August 2023 become the dates.



Frequent Visitor

 Hi FreemanZ, thanks for the response.


Every year between July and August, my organization advertises certain positions. Unfortunately, they also sometimes advertise outside of this date range. I am only interested in positions advertised in this window (01 July to 31 August), and I am only interested in the most recent window. I want to show:


1. The number of positions advertised within the most recent July/August period.

2. The number of positions filled since the last window.


I have tried linking a dates table to the created date, and then adding a column which specifies which month in the year it is. It is then easy to select the months in each year. The issue I am having is selecting the most recent July/August months.



Super User
Super User

hi @jacques_412 

could you elaborate your case?

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.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

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