DAX Turn Around Time Calculation with different/multiple condition

To convert the given SQL logic for TAT0 and TAT1 into DAX, you'll need to create calculated columns or measures based on the conditions specified. Below are the DAX expressions to replicate the SQL logic.

TAT0 Calculation

Here's how you can create the TAT0 column in DAX:

TAT0 = 
IF (
    ISBLANK('YourTable'[r1_created]),
    BLANK(),
    IF (
        CONTAINSSTRING('YourTable'[r1_line], "ABC") &&
        'YourTable'[r1_status] = "Completed",
        DATEDIFF('YourTable'[r1_created], 'YourTable'[receipt_dt], DAY),
        BLANK()
    )
)

TAT1 Calculation

Here's the DAX expression for TAT1:

TAT1 = 
IF (
    NOT ISBLANK('YourTable'[r1_po]) &&
    NOT ISBLANK('YourTable'[r1_ended]) &&
    UPPER('YourTable'[r1_status]) = "COMPLETED" &&
    (
        NOT CONTAINSSTRING(UPPER('YourTable'[r1_line]), "ABC") &&
        UPPER('YourTable'[r1_line]) <> "R_And"
    ) &&
    ISBLANK('YourTable'[r2_po]) &&
    ISBLANK('YourTable'[r2_status]),
    DATEDIFF('YourTable'[r1_created], 'YourTable'[receipt_dt], DAY),
    IF (
        NOT ISBLANK('YourTable'[r1_po]) &&
        NOT ISBLANK('YourTable'[r1_ended]) &&
        UPPER('YourTable'[r1_status]) = "COMPLETED" &&
        LEFT('YourTable'[r1_model], 3) = "CAB" &&
        NOT ISBLANK('YourTable'[r2_po]) &&
        NOT ISBLANK('YourTable'[r2_ended]) &&
        'YourTable'[r2_status] = "Completed",
        DATEDIFF('YourTable'[r1_ended], 'YourTable'[r1_created], DAY),
        0
    )
)