cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

Hi

I am having headcount data, which has a target date. The target date is the hire date of the employees

The target date looks like below

 Target Date 01/01/2020 02/01/2021 01/01/2021 01/01/2020 - 02/01/2020 01/01/2020 01/03/2020 01/04/2021

I wanted to calculate cumulative headcount and wanted to visualize over the month

I used below Dax measure

My data stored in a Headcount table

Above Dax, measures are not working

1 ACCEPTED SOLUTION
Super User

Hi, @Jason2500

I am not quite sure how the outcome looks like.

I tried to create a sample pbix file by myself, and please check whether it is what you are looking for.

All measures are in the sample pbix file. (Link down below).

Or, please draw visualizations of your desired outcome. It will be much more helpful for me to come closer.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

2 REPLIES 2
Super User

Hi,

Ensure you have a Calendar Table with calculated column formulas for Year and Month Name and Month Number.  Sort the Month name by the month number.  Build a relationship from the Hire Date column to the Date column of the Calendar Table.  Build 2 slicers for Year and Month from the Calendar Table.  Select any one Year and Month.  Write these measures:

Cumulative HC = CALCULATE([TotalHC],datesytd(Calendar[Date],"31/12"))

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

Hi, @Jason2500

I am not quite sure how the outcome looks like.

I tried to create a sample pbix file by myself, and please check whether it is what you are looking for.

All measures are in the sample pbix file. (Link down below).

Or, please draw visualizations of your desired outcome. It will be much more helpful for me to come closer.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors