Forum Discussion

Deeks's avatar
Deeks
Frequent Visitor
3 years ago

Please help with calculated column (If statements)

Hi, posting this again as I don’t think my previous post was clear.     I’m trying to create a column to determine if an order has been shipped on time. An order is considered to be shipped on time...
"Calculated Column"
"dax code"
"Need Help"
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

pelase try 

on time?column =
SWITCH(
    TRUE(),
    AND(OOR[isShipped]=TRUE(),OOR[Original Ship Date] <= OOR[Current Ship Date] + 3),"Yes","No")



if i didnt understand your question , can you please be more specific on what your goal is and waht column we should look at?


  • Deeks's avatar
    Deeks
    Frequent Visitor
    3 years ago

    Hi, not quite but your code gave me a hint as to how I could calculate what was needed, and have now managed to solve it using switch statements. Thank you! 🙂