If statement too many arguments

[revisr]

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?

[revisr]

That did it thanks!!

[Wilson_]

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
)

[uzuntasgokberk · Accepted solution]

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),

         1

           )

)

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

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