Forum Discussion

Dawn85's avatar
Dawn85
Frequent Visitor
5 years ago
Solved

Help with Excel multiple IF formula converted to DAX

Hello, I have this formula in Excel and I need it rewritten in DAX but I am unsure how to do this. I am very very new to DAX and so far have only been able to do the basics. I hope someone can hel...
  • lbendlin's avatar
    lbendlin
    5 years ago

    Column =
    SWITCH (
        TRUE (),
        ISBLANK ( 'winnipeg erp_workorder'[Date Shipped] ), BLANK (),
        ISBLANK ( 'winnipeg erp_workorder'[Date Exchanged] ),
            'winnipeg erp_workorder'[Date Shipped] - 'winnipeg erp_workorder'[Date Approved] + 1,
        'winnipeg erp_workorder'[Date Shipped] - 'winnipeg erp_workorder'[Date Exchanged] + 1 - 'winnipeg erp_workorder'[Paused Days Total]
    )

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Column =
SWITCH (
    TRUE (),
    ISBLANK ( 'winnipeg erp_workorder'[Date Shipped] ), BLANK (),
    ISBLANK ( 'winnipeg erp_workorder'[Date Exchanged] ),
        'winnipeg erp_workorder'[Date Shipped] - 'winnipeg erp_workorder'[Date Approved] + 1,
    'winnipeg erp_workorder'[Date Shipped] - 'winnipeg erp_workorder'[Date Exchanged] + 1 - 'winnipeg erp_workorder'[Paused Days Total]
)

Dawn85's avatar
Dawn85
Frequent Visitor
5 years ago

Perfect! This is exactly what I was looking for, Thank you very much!