topic Re: Help with Excel multiple IF formula converted to DAX in DAX Commands and Tips

Help with Excel multiple IF formula converted to DAX

Dawn85 — Fri, 09 Apr 2021 18:03:34 GMT

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 help!

Excel formula:

Excel Formula:

=IF([@[Date Shipped]]="","",IF([@[Date Exchanged]]="",[@[Date Shipped]]-[@[Date Approved]]+1,[@[Date Shipped]]-[@[Date Exchanged]]+1)-([@[Paused Days (Total)]]*([@[Paused Days (Total)]]<>"")))

My attempt was disastrous and clearly not correct:

Code:

Column = IF(ISBLANK('winnipeg erp_workorder'[Date Shipped]),BLANK(),IF(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)-(IF(NOT(ISBLANK('winnipeg erp_workorder'[Paused Days Total],'winnipeg erp_workorder'[Paused Days Total]*'winnipeg erp_workorder'[Paused Days Total]))))

Thank you

Re: Help with Excel multiple IF formula converted to DAX

lbendlin — Thu, 15 Apr 2021 17:01:19 GMT

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]
)

Re: Help with Excel multiple IF formula converted to DAX

Dawn85 — Thu, 15 Apr 2021 17:56:10 GMT

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

Re: Help with Excel multiple IF formula converted to DAX

lbendlin — Thu, 15 Apr 2021 17:59:28 GMT

By the way, the formatting is courtesy of www.daxformatter.com - a free service that helps you understand your own DAX code better - I use it all the time.

Re: Help with Excel multiple IF formula converted to DAX

Dawn85 — Thu, 15 Apr 2021 18:06:09 GMT

I am brand new to DAX so I have a lot to learn, any tool is greatly appreciated, Thank you!