power bi formula doesn't work due to number date format setup

[Anonymous]

Hi,

try to create a new measure, but got a error below. as you can see, power bi doesn't recognize the "[" symbol after Earlier function.

i had experience similar issues before, it was fixed after change the number/date/time setup in my laptop. i don't remember how i did the setup last time. Can someone help?

[v-yuta-msft · Accepted solution]

@Anonymous ,

You need to input parameter to EARLIER() function like below:

direct reports =
CALCULATE (
    COUNTA ( 'AnnualBaseSalary20191006193150'[Manger] ),
    FILTER ( 'AnnualBaseSalary20191006193150', [Manger] = EARLIER ( [Manger] ) )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.