Forum Discussion
Headcount Calculation
- 3 years ago
Thanks for reverting tamerj1.
Found the solution using similar logic for the YearMonth ID.
F_OpeningHC =
var yr = SELECTEDVALUE(Dim_time[Year])
var ml = SELECTEDVALUE(Dim_time[MonthLoad])
VAR yearmonth = CALCULATE(MIN(sf_CSS[time_id]),sf_CSS[sf_year]=yr,sf_CSS[sf_month_load]=ml)Return
CALCULATE(SUM(sf_CSS[hc_opening]),sf_CSS[sf_year]=yr,sf_CSS[sf_month_load]=ml,sf_CSS[time_id]= yearmonth)F_ClosingHC =
var yr = SELECTEDVALUE(Dim_time[Year])
var ml = SELECTEDVALUE(Dim_time[MonthLoad])
VAR yearmonth = CALCULATE(MAX(sf_CSS[time_id]),sf_CSS[sf_year]=yr,sf_CSS[sf_month_load]=ml)Return
CALCULATE(SUM(sf_CSS[hc_closing]),sf_CSS[sf_year]=yr,sf_CSS[sf_month_load]=ml,sf_CSS[time_id]=yearmonth)
Thanks for reverting tamerj1.
Found the solution using similar logic for the YearMonth ID.
F_OpeningHC =
var yr = SELECTEDVALUE(Dim_time[Year])
var ml = SELECTEDVALUE(Dim_time[MonthLoad])
VAR yearmonth = CALCULATE(MIN(sf_CSS[time_id]),sf_CSS[sf_year]=yr,sf_CSS[sf_month_load]=ml)
Return
CALCULATE(SUM(sf_CSS[hc_opening]),sf_CSS[sf_year]=yr,sf_CSS[sf_month_load]=ml,sf_CSS[time_id]= yearmonth)
F_ClosingHC =
var yr = SELECTEDVALUE(Dim_time[Year])
var ml = SELECTEDVALUE(Dim_time[MonthLoad])
VAR yearmonth = CALCULATE(MAX(sf_CSS[time_id]),sf_CSS[sf_year]=yr,sf_CSS[sf_month_load]=ml)
Return
CALCULATE(SUM(sf_CSS[hc_closing]),sf_CSS[sf_year]=yr,sf_CSS[sf_month_load]=ml,sf_CSS[time_id]=yearmonth)