Going Crazy with a stupid thing for sure

[Orlando_Tuga]

Hi all

I am new in power bi and using it for a couple of weeks and learning with google and youtube 🙂

Can anyone help me as i have an error : 'The syntax for ',' is incorrect. (DAX( IF(.....'

the comands are very basic and i use them for a new colum:

Robot_TtF =

    IF(

        AND( EPCC_Cases[Title]<>BLANK() , EPCC_Cases[RepairType]="In House" ) ,

        IF(

            OR( EPCC_Cases[Status]="Closed" , EPCC_Cases[Status]="Shipped to Customer" ) ,

            IF(

                AND( EPCC_Cases[DateReceivedAtEPCC]<>blank , EPCC_Cases[DateShipped]<>BLANK() ) ,

                DATEDIFF(EPCC_Cases[DateReceivedAtEPCC].[Date] , EPCC_Cases[DateShipped].[Date] , DAY) ,

                IF(

                    EPCC_Cases[DateReceivedAtEPCC]=BLANK() ,

                    1000 ,

                    IF(

                        EPCC_Cases[DateShipped]=BLANK() ,

                        2000

                    )

                )

            ) ,

            IF(

                EPCC_Cases[DateReceivedAtEPCC]<>BLANK() ,

                DATEDIFF(EPCC_Cases[DateReceivedAtEPCC].[Date] , TODAY() , DAY) ,

                4000

            )

        ) ,

        5000

    )

Can any one help me and see were the error is as i am not.
Thanks

[Anonymous · Accepted solution]

Hi @Orlando_Tuga ,

Try using the following expression:

Robot_TtF =
IF(
    AND(EPCC_Cases[Title] <> BLANK(), EPCC_Cases[RepairType] = "In House"),
    IF(
        OR(EPCC_Cases[Status] = "Closed", EPCC_Cases[Status] = "Shipped to Customer"),
        IF(
            AND(EPCC_Cases[DateReceivedAtEPCC] <> BLANK(), EPCC_Cases[DateShipped] <> BLANK()),
            DATEDIFF(EPCC_Cases[DateReceivedAtEPCC], EPCC_Cases[DateShipped], DAY),
            IF(
                EPCC_Cases[DateReceivedAtEPCC] = BLANK(),
                1000,
                IF(
                    EPCC_Cases[DateShipped] = BLANK(),
                    2000
                )
            )
        ),
        IF(
            EPCC_Cases[DateReceivedAtEPCC] <> BLANK(),
            DATEDIFF(EPCC_Cases[DateReceivedAtEPCC], TODAY(), DAY),
            4000
        )
    ),
    5000
)

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[Orlando_Tuga]

Tried it and does not work.

[Anonymous · Accepted solution]

Hi @Orlando_Tuga ,

Try using the following expression:

Robot_TtF =
IF(
    AND(EPCC_Cases[Title] <> BLANK(), EPCC_Cases[RepairType] = "In House"),
    IF(
        OR(EPCC_Cases[Status] = "Closed", EPCC_Cases[Status] = "Shipped to Customer"),
        IF(
            AND(EPCC_Cases[DateReceivedAtEPCC] <> BLANK(), EPCC_Cases[DateShipped] <> BLANK()),
            DATEDIFF(EPCC_Cases[DateReceivedAtEPCC], EPCC_Cases[DateShipped], DAY),
            IF(
                EPCC_Cases[DateReceivedAtEPCC] = BLANK(),
                1000,
                IF(
                    EPCC_Cases[DateShipped] = BLANK(),
                    2000
                )
            )
        ),
        IF(
            EPCC_Cases[DateReceivedAtEPCC] <> BLANK(),
            DATEDIFF(EPCC_Cases[DateReceivedAtEPCC], TODAY(), DAY),
            4000
        )
    ),
    5000
)

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[Orlando_Tuga]

Thanks

[Orlando_Tuga · Accepted solution]

It worked, was it due to the spaces?

[Anonymous]

Hi @Orlando_Tuga ,

The main reason is the Date.

Best regards,
Community Support Team_ Scott Chang

[Jihwan_Kim]

Hi,

If your setting shows "," as error, please try ";"