topic Re: If statement too many arguments in DAX Commands and Tips

If statement too many arguments

revisr — Thu, 15 Aug 2024 13:16:05 GMT

I am brand new to DAX. In one of my lessons I was told to enter an IF statement:

Customer Age =

IF(

FORMAT('Customer'[Birth Date], "mmdd") <= FORMAT(TODAY(), "mmdd"),

DATEDIFF('Customer'[Birth Date], TODAY(), YEAR),

DATEDIFF('Customer'[Birth Date], TODAY(), YEAR),-1)

It is telling me I have more than 3 arguments. My column has error. Where wm I going wrong?

Re: If statement too many arguments

uzuntasgokberk — Mon, 14 Jul 2025 20:33:57 GMT

Hello revisr,

If statement syntax is IF(<logical_test>, <value_if_true>[, <value_if_false>])

IF function (DAX) - DAX | Microsoft Learn

Therefore, you code should be like this:

IF(
FORMAT('Customer'[Birth Date], "mmdd") <= FORMAT(TODAY(), "mmdd"),

DATEDIFF('Customer'[Birth Date], TODAY(), YEAR),

IF(

FORMAT('Customer'[Birth Date], "mmdd") > FORMAT(TODAY(), "mmdd"),

DATEDIFF('Customer'[Birth Date], TODAY(), YEAR),

)

Re: If statement too many arguments

revisr — Thu, 15 Aug 2024 13:30:30 GMT

That did it thanks!!

Re: If statement too many arguments

Wilson_ — Mon, 19 Aug 2024 03:02:27 GMT

Hi revisr,

Looks like the formula uzuntasgokberk provided was unnecessarily complex. You were on the right track with your original measure. You just had an extra comma in your measure, before the -1 at the end. The comma made Power BI think the -1 was a fourth argument in your IF function. Hopefully that makes sense.

You had:

IF ( FORMAT ( 'Customer'[Birth Date], "mmdd" ) <= FORMAT ( TODAY(), "mmdd" ), DATEDIFF ( 'Customer'[Birth Date], TODAY(), YEAR ), DATEDIFF ( 'Customer'[Birth Date], TODAY(), YEAR ), - 1 )

However, what you meant was:

IF ( FORMAT ( 'Customer'[Birth Date], "mmdd" ) <= FORMAT ( TODAY(), "mmdd" ), DATEDIFF ( 'Customer'[Birth Date], TODAY(), YEAR ), DATEDIFF ( 'Customer'[Birth Date], TODAY(), YEAR ) - 1 )