Dates Parameters for Initial and Final Headcount

AnaAlbano · ‎06-27-2023

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:

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]),

1,

MONTH

))

Final

CM_Last Headcount2 =

CALCULATE(

COUNTROWS(Combined),

Combined[CC_tbl_Combined_Table2]="Headcount",

DATEADD(

dCalendar[Date],

9,

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.

Spoiler

Thank you so much!

Ana