Dates Parameters for Initial and Final Headcount

AnaAlbano — Tue, 27 Jun 2023 11:20:58 GMT

Hello Community!

I am trying to use a paramenter in my dashboard, but I am not getting the result I have. The context is: I have to show inital and final headcount and to count the number of employees, I use a column where I have "headcount", as in this table a have others groups as well, such as hires and so on.

I could create a initial and final, but when I try to use a paramenter to give user the possibility to show from when start/end, my headcount start to acumulate. These are my measures:

Initial:

CM_First Headcount =

CALCULATE(

COUNTROWS(Combined),

(Combined[CC_tbl_Combined_Table2]="Headcount"),

DATESINPERIOD(dCalendar[Date],

MIN(dCalendar[Date]),

MONTH

))

Final

CM_Last Headcount2 =

CALCULATE(

COUNTROWS(Combined),

Combined[CC_tbl_Combined_Table2]="Headcount",

DATEADD(

dCalendar[Date],

MONTH))

Does any would know how I should write to be able to use the parameter and if the person selects, for exemple: start point set/2022 and end point jan/23, to show the hires in this between?

I tryed to attach a file as reference, but I could not see the option to do it.

Thank you so much!

Ana

topic Dates Parameters for Initial and Final Headcount in DAX Commands and Tips

Dates Parameters for Initial and Final Headcount