Forum Discussion

surajde's avatar
surajde
Helper I
3 years ago
Solved

Expression that yeild variant data-type error

Hi All,   Need your help with below data type where I'm getting error when trying to apply a dax on Met as a conditional column.    Sample Data:  OPENED_DATE_CST RESTORED_DATE_CST CLOSED_DA...
Need Help
Show and Tell
Tips and Tricks
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    Met =
IF (
    'AOTS Daily CSL 54 1'[TICKET_STATE] = "Cancel",
    "NA",
    IF (
        OR (
            'AOTS Daily CSL 54 1'[TICKET_STATE] = "Closed",
            'AOTS Daily CSL 54 1'[TICKET_STATE] = "Ready to Close"
        ),
        IF (
            'AOTS Daily CSL 54 1'[TTR_Hours] <= 'AOTS Daily CSL 54 1'[Target (Hours)],
            "1"
        ),
        IF (
            'AOTS Daily CSL 54 1'[OPENED_DATE_CST] + 'AOTS Daily CSL 54 1'[Days to Due Date]
                > TODAY (),
            "TBD",
            "0"
        )
    )
)
surajde's avatar
surajde
Helper I
3 years ago

Hi johnt75 , 

 

Please see below formula for GreaterThanOpenDue column. basically I then tried creating to avoid last calculation of dates 

 

Met =
    IF('AOTS Daily CSL 54 1'[TICKET_STATE]="Cancel","NA",
    IF(OR(
        'AOTS Daily CSL 54 1'[TICKET_STATE]="Closed",
        'AOTS Daily CSL 54 1'[TICKET_STATE]="Ready to Close"),
        IF('AOTS Daily CSL 54 1'[TTR_Hours]<='AOTS Daily CSL 54 1'[Target (Hours)],1),
        IF('AOTS Daily CSL 54 1'[OPENED_DATE_CST]+'AOTS Daily CSL 54 1'[Days to Due Date]>TODAY(),"TBD",0))
 

 

 

johnt75's avatar
johnt75
Super User
3 years ago

Try

Met =
IF (
    'AOTS Daily CSL 54 1'[TICKET_STATE] = "Cancel",
    "NA",
    IF (
        OR (
            'AOTS Daily CSL 54 1'[TICKET_STATE] = "Closed",
            'AOTS Daily CSL 54 1'[TICKET_STATE] = "Ready to Close"
        ),
        IF (
            'AOTS Daily CSL 54 1'[TTR_Hours] <= 'AOTS Daily CSL 54 1'[Target (Hours)],
            "1"
        ),
        IF (
            'AOTS Daily CSL 54 1'[OPENED_DATE_CST] + 'AOTS Daily CSL 54 1'[Days to Due Date]
                > TODAY (),
            "TBD",
            "0"
        )
    )
)
  • surajde's avatar
    surajde
    Helper I
    3 years ago

    johnt75  Bingo!! it worked!! 

     

    Thanks a ton. You just solved my long pending query in a minute.