using fucntions IF, &&(AND), Colum with data and Column without Data

[perezco]

Could someone help to find the problem, 

I am trying to category data result from diferent columns that has data or not. 
lookingto get:

	HD_ACT	HD_EXPD	C_ACT	C_EXPD	result
HD_ACT	1	x	x	x	HD_ACT
HD_EXPD	x	1	x	x	HD_EXPD
C_ACT	1	x	x	x	C_ACT
C_EXPD	x	1	x	x	C_EXPD
HD_ACT	1	1	x	x	HD
HD_EXPD	x	x	1	1	C
C_ACT	1	x	1	x	BOTH_ACT
C_EXPD	x	1	x	1	BOTH_EXPD

But fo some reason the dax is not working.[this is a column calculation]

AAA =
VAR ISData_HD_ACT =
    NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) --true, exist data
VAR ISBlank_HD_ACT =
    ISBLANK ( data[HD_ACT_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_HD_EXPD =
    NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) --true, exist data
VAR ISBlank_HD_EXPD =
    ISBLANK ( data[HD_EXPD_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_C_ACT =
    NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) --true, exist data
VAR ISBlank_C_ACT =
    ISBLANK ( data[HD_ACT_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_C_EXPD =
    NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) --true, exist data
VAR ISBlank_C_EXPD =
    ISBLANK ( data[HD_EXPD_SKU_Number] ) --true, no data
----------------------------------------------------------------------
RETURN
    IF (
        ISData_HD_ACT && ISBlank_HD_EXPD
            && ISBlank_C_ACT
            && ISBlank_C_EXPD,
        "HD_ACT",
        IF (
            ISData_HD_EXPD && ISBlank_HD_ACT
                && ISBlank_C_ACT
                && ISBlank_C_EXPD,
            "HD_EXPD",
            IF (
                ISData_C_ACT && ISBlank_HD_ACT
                    && ISBlank_HD_EXPD
                    && ISBlank_C_EXPD,
                "C_ACT",
                IF (
                    ISData_C_EXPD && ISBlank_HD_ACT
                        && ISBlank_HD_EXPD
                        && ISBlank_C_ACT,
                    "C_EXPD",
                    IF (
                        ISData_HD_ACT && ISData_HD_EXPD
                            && ISBlank_C_ACT
                            && ISBlank_C_EXPD,
                        "HD",
                        IF (
                            ISData_C_ACT && ISData_C_EXPD
                                && ISBlank_HD_ACT
                                && ISBlank_HD_EXPD,
                            "C",
                            IF (
                                ISData_HD_ACT && ISData_C_ACT
                                    && ISBlank_HD_EXPD
                                    && ISBlank_C_EXPD,
                                "Both ACT",
                                IF (
                                    ISData_HD_EXPD && ISData_C_EXPD
                                        && ISBlank_HD_ACT
                                        && ISBlank_C_ACT,
                                    "Both EXPD",
                                    "failure"
                                )
                            )
                        )
                    )
                )
            )
        )
    )

thanks in advance.

[perezco · Accepted solution]

I found the error. it has inside of the logic, no symtax issue.

[amitchandak]

@perezco , can you explain the logic behind the calculation. As if syntax seems fine, You can use switch

Order of condition is important

AAA =
VAR ISData_HD_ACT =
    NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) --true, exist data
VAR ISBlank_HD_ACT =
    ISBLANK ( data[HD_ACT_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_HD_EXPD =
    NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) --true, exist data
VAR ISBlank_HD_EXPD =
    ISBLANK ( data[HD_EXPD_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_C_ACT =
    NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) --true, exist data
VAR ISBlank_C_ACT =
    ISBLANK ( data[HD_ACT_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_C_EXPD =
    NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) --true, exist data
VAR ISBlank_C_EXPD =
    ISBLANK ( data[HD_EXPD_SKU_Number] ) --true, no data
----------------------------------------------------------------------
RETURN
Switch ( true() ,
        ISData_HD_ACT && ISBlank_HD_EXPD
            && ISBlank_C_ACT
            && ISBlank_C_EXPD,
        "HD_ACT",
   ISData_HD_EXPD && ISBlank_HD_ACT
                && ISBlank_C_ACT
                && ISBlank_C_EXPD,
            "HD_EXPD",
     ISData_C_ACT && ISBlank_HD_ACT
                    && ISBlank_HD_EXPD
                    && ISBlank_C_EXPD,
                "C_ACT",
    ISData_C_EXPD && ISBlank_HD_ACT
                        && ISBlank_HD_EXPD
                        && ISBlank_C_ACT,
                    "C_EXPD",
    ISData_HD_ACT && ISData_HD_EXPD
                            && ISBlank_C_ACT
                            && ISBlank_C_EXPD,
                        "HD",
    ISData_C_ACT && ISData_C_EXPD
                                && ISBlank_HD_ACT
                                && ISBlank_HD_EXPD,
                            "C",
    ISData_HD_ACT && ISData_C_ACT
                                    && ISBlank_HD_EXPD
                                    && ISBlank_C_EXPD,
                                "Both ACT",
    ISData_HD_EXPD && ISData_C_EXPD
                                        && ISBlank_HD_ACT
                                        && ISBlank_C_ACT,
                                    "Both EXPD",
     "failure"
                              
    )	

[perezco · Accepted solution]

I found the error. it has inside of the logic, no symtax issue.

[Icey · Accepted solution]

Hi @perezco ,

Glad to hear that you have solved the issue.

And I find that, it is just caused by this:

---

VAR ISData_C_ACT =
NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) )  -----------Change to data[C_ACT_SKU_Number]

VAR ISBlank_C_ACT =
ISBLANK ( data[HD_ACT_SKU_Number] )    -----------Change to data[C_ACT_SKU_Number]

VAR ISData_C_EXPD =
NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) )  -----------Change to data[C_EXPD_SKU_Number]

VAR ISBlank_C_EXPD =
ISBLANK ( data[HD_EXPD_SKU_Number] ) -----------Change to data[C_EXPD_SKU_Number]

---

Right?

Best Regards,

Icey

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