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
Icon for Microsoft Employee rankMicrosoft 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"
)