Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, this should be fairly easy, but I am a beginner!
My data has hire month for employees,
Example
Employee | Hire date | Other filter |
Worker 1 | 01/02/2022 | Filled |
Worker 2 | 01/02/2022 | Accepted |
Worker 3 | 02/11/2022 | Filled |
Worker 4 | 03/22/2022 | Filled |
Worker 5 | 03/25/2022 | Filled |
What I need is to show is Total Head Count measure.. for Jan = 102, Feb = 103, Mar = 105 (so it adding number of hires from previous months)
I have a DateDim table... (if that's useful?)
Also, what if I want to calculate only the ones that are (Filled)?
Thank you in advance!
@amitchandak thank you for your quick response..
I do not have termination date, and I tried your calculation like this:
HireTotals = CALCULATE(Count('Table'[Hire date]),filter(DimDate,DimDate[Date] <=maxx(DimDate,DimDate[Date]))) + [initial Emp]
And I got this (total by month) not the (total year to date) = adding totals per month
I tried to use the quick measure function to measure YTD and it came up with this expression
Any thoughts?
Thank you!
@NovWor , if we have hire and termination date both then we use, log like the one here
else we use logic like
[Intial Emp] + CALCULATE(Count(Hire[EmpID]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(leaver[leaver]),filter(date,date[date] <=maxx(date,date[date])))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |