Showing count of new start employees by month

[hallang]

Hi,

I am trying to add a 'card' to show the number of new start employees in any current month.  I ahve copied a formula from google but it doesnt seem to be working -

New Start Employee Count =

VAR CurrentMonthStart = STARTOFMONTH(TODAY())

VAR CurrentMonthEnd = ENDOFMONTH(TODAY())

RETURN

CALCULATE(

    COUNTROWS(Sheet1),

    Sheet1[start date ] >= CurrentMonthStart,

    Sheet1[start date ] <= CurrentMonthEnd

)

Can anyone suggest how I can do this?

[BenjaminSNN · Accepted solution]

Hey!

I think STARTOFMONTH() and ENDOFMONTH() can only be used in a table context. You should use EOMONTH(). 
I've altered the code for you:

New Start Employee Count =

VAR CurrentMonthStart = EOMONTH(TODAY(), -1) + 1 // End of last month plus one day is first of this month

VAR CurrentMonthEnd = EOMONTH(TODAY(), 0)

RETURN

CALCULATE(

    COUNTROWS(Sheet1),

    Sheet1[start date ] >= CurrentMonthStart,

    Sheet1[start date ] <= CurrentMonthEnd

)

[hallang]

Hi!

That seems to work perfectly! Thank you so much!!