Forum Discussion
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...
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
Super User
Super UserBy 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.
I am brand new to DAX so I have a lot to learn, any tool is greatly appreciated, Thank you!