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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jacques_412
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.

 

 

2 REPLIES 2
jacques_412
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.

 

Thanks

FreemanZ
Super User
Super User

hi @jacques_412 

could you elaborate your case?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors