Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated Column question

Hello Community  -  I've been tasked by management to track the days between various dates.    These date difference formulas I have already created.    The 2nd part of the request, is that we need...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Looks like you could just make a calculated column with a SWITCH(TRUE(), Order[Amount] <40000, "Quick Ship", Order[Amount] <100000, "10 Day" ... and so on.  You could also then make a Due Date column with another SWITCH() to add days to the CH Release Date based on the category value in the new column.

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Looks like you could just make a calculated column with a SWITCH(TRUE(), Order[Amount] <40000, "Quick Ship", Order[Amount] <100000, "10 Day" ... and so on.  You could also then make a Due Date column with another SWITCH() to add days to the CH Release Date based on the category value in the new column.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks mahoneypat 

     

    Here is the final result

     

    Shipment Category =
    SWITCH( TRUE(),
    'Flu Shipped'[Order Value] <= 40000,"Quick Ship",
    'Flu Shipped'[Order Value] < 100000,"10 Day",
    "30 Day"
    )