Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

MTD

I'm trying to calculate billable hours for MTD.    I tried the below measure however, it is showing as blank.  MTD Billable = CALCULATE(SUM(Utilisation[ChargeableHours]), DATESMTD('Work Period'[D...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Greg_Deckler  I'm not sure I did the middle one right

 

MTD Billable Hours =
CALCULATE([Chargeable Hours],
FILTER(ALL('Work Period'[Date]),
'Work Period'[Date]=MAX('Work Date'[Date]) && 'Work Period'[Date]<= MAX('Work Period'[Date]
)))
 
It is still showing blank
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous So the middle one requires a helper column that combines Year and Month like 202301, 202302, 202303. Basically a calculated column like YEAR('Date'[Date]) * 100 + MONTH('Date'[Date])