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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JGARROD
Helper I
Helper I

Filtereing two columns with one filter - dates

Hi, i have a column with employee start and end dates for various periods of time off. 

 

I want to be able to filter by month and it to show me any lines where there is going to be days leave from an emplyee in that month.

 

JGARROD_0-1684747249577.png

For example in the highlighted line when i select 'December 2023' in my filter i would like it to show the line (as well as other holiday in december 2023) but then when i select 'Jan 2024' it should also show the highlighted line. 

 

Many thanks

1 REPLY 1
amitchandak
Super User
Super User

@JGARROD ,Have a date table, join with both tables and one join will active and one will inactive and then you can userelationship in measure to activate the inactive join

 

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

 

or file attached

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.