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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
doingdata
Frequent Visitor

to find # of employees AS OF [Quarter] & [Year] from a calculated measure

Tables

Employee:  Employee ID, Start Date, End Date, Gender, Management Level, Gender Diverse Executives (Calculated Measure)

Date: Date, Day, Month, Quarter, Year, etc.

 

Inactive Relationships:

Start Date <---> 'Date'[Date]

End Date <---> 'Date'[Date]

 

Looking for a way to calculate X number of Active, Gender Diverse Executives on ANY given Quarter-Year.

 

Since there is no static date (like effective date, date of promotion), I'm struggling to filter out this specified group in a given date range.

1 REPLY 1
doingdata
Frequent Visitor

Dataset contains records with Active Employees as of 01-01-2021 to 03-31-2023

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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