Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello!
I have a table that provides employee ID, their hired date and term date. By using hired and term date, i need to display how many team members were active per month.
For example, row 2-4 will be considered as active employees as of January 2021 and row 5-8 will be considered as active employees as of Feb 2021. I am unsure I should create this into dax. Appreciate your help!
Hi @always_joy
1. Disconnect your dates table from fact table.
2. Use this measure:
Hi @always_joy ,
According to your sample data, for Jan-21, the count of Active Hires seems to be 6 not 3.
In addition, not very clear about this:
If an employee has future term date for the current month, i still want to be able to count that employee
but the current dax is removing all employees with the term date for the current month. How can I update the below dax to capture that?
So could you please provide me with more details about your table and your problem to help us clarify your scenario? Or share me with your pbix file after removing sensitive data.
Refer to:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
@always_joy , refer m blog on same topic
Or the attached file after signature
Thank you @amitchandak. A quick question regarding to current employees.
If an employee has future term date for the current month, i still want to be able to count that employee
but the current dax is removing all employees with the term date for the current month. How can I update the below dax to capture that? Thank you!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
69 | |
46 | |
39 | |
33 |
User | Count |
---|---|
163 | |
110 | |
61 | |
51 | |
40 |