Too many arguments were passed to the DATE function. The minimum argument count for the function is

[Anonymous]

I am receiving an error as below, but couldn't see the error, can someone please advise?

I am trying to mesure results of hiring in between May 01 of year reference to May 1st of year refererence + 1, so that year after year, I only need to change the reference year. Any other ways of getting this result or any extra tips, please feel free to recommend,

Thanks in advamce.

[Greg_Deckler · Accepted solution]

Just use 

DATE( _anoFiscalRerferencia, 5, 1 ) and DATE( _anoFiscalRerferencia + 1, 5, 1 )

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

check this

Contagem contratações ano fiscal =

VAR _anoFiscalReferencia = 2024

RETURN CALCULATE(
    SUM('Full Report'[Number of Applications In State: Hired]),
    FILTER(
        'tableName',
        'tableName'[Hired Position Hire Date] >= DATE(_anoFiscalReferencia, 5, 1) &&
        'tableName'[Hired Position Hire Date] < DATE(_anoFiscalReferencia + 1, 5, 1)
    )
)

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

check this

Contagem contratações ano fiscal =

VAR _anoFiscalReferencia = 2024

RETURN CALCULATE(
    SUM('Full Report'[Number of Applications In State: Hired]),
    FILTER(
        'tableName',
        'tableName'[Hired Position Hire Date] >= DATE(_anoFiscalReferencia, 5, 1) &&
        'tableName'[Hired Position Hire Date] < DATE(_anoFiscalReferencia + 1, 5, 1)
    )
)

[shafiz_p]

Hi @Anonymous  You have passed too many arguments inside date function. It would be Date (_anoFiscalReferencia,5,1). Remove Year, Month, Day function from Date Function. Just provide value.

Hope this helps!!

If this solved your problem, please accept it as a solution!!

[Anonymous]

Hi @shafiz_p Appreciate you taking the time to assist,

It still shows the error unfortunatelly.

[shafiz_p · Accepted solution]

@Anonymous  I don't see any problem in your formula. Please delete and rewrite the measure.

[Anonymous]

OMG 

Can't believe it solved! 🤓

I guess I made so many changes that Power BI could not keep track lol 🤣

Thanks again!

And thanks everyone else for taking the time, it was super fast!

[Greg_Deckler]

@Anonymous  I don't suppose you have a language turned on that needs ; instead of , for DAX?

[Anonymous]

Hi @Greg_Deckler ,

Not sure if that is what you meant, but I also tried traslated, and it shows the same error. Regardless, my Power BI set up is in English anyways, so not sure how to fix it

[Greg_Deckler · Accepted solution]

Just use 

DATE( _anoFiscalRerferencia, 5, 1 ) and DATE( _anoFiscalRerferencia + 1, 5, 1 )