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

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.

Frequent Visitor

## I would like to calculate headcount month over month based on hiredate.

 Input Raw Data Hire Date Name Location 10/29/2019 A AAA 10/30/2019 B BBB 3/5/2012 C CCC 5/10/2018 E AAA 6/7/2018 F BBB 8/25/2017 G CCC 9/13/2016 H AAA 1/19/2020 I BBB 2/21/2020 I CCC 3/19/2020 I AAA 3/9/2020 I BBB

 Desired Output1 Number of Headcount per Month as on 2020 Headcount by month Jan'20 8 Feb'20 9 Mar'20 11
3 REPLIES 3
Resident Rockstar

@mbl ,

You can create a measure with the below DAX and use for this purpose

``running headcount = CALCULATE(COUNT('Table (2)'[Name]), FILTER(ALL('Table (2)'), 'Table (2)'[Hire Date] <= MAX('Table (2)'[Hire Date])))``

Regards,

Community Champion

Something like this? You can use date table to slice the data.

``HeadCount = COUNTROWS( HireData )``
``````Running Headcount =
VAR Result =
CALCULATE (
[HeadCount],
FILTER ( ALL ( Dates ), Dates[Date] <= MAX ( Dates[Date] ) )
)
RETURN
IF ( [HeadCount] > 0, Result, BLANK () )``````

Community Champion

HI @mbl ,

See if this helps.

Watch this video from 5:38 onwards.

https://www.youtube.com/watch?v=rsx43g7TBBs

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

## Helpful resources

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors