Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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])))
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.