Filter table by column then on filter value increase date by 14 days all in 1 new column

[bzafft123]

Hello,

I have a table with the following columns Profit Center, Requested Date, and Target Delivery Date. I'm looking for the Target Delivery Date to be updated by i.e. 14 days if Profit Center is Preschool or if Profit Center is Schools 30 days. I want these updates all in one new column.  

Example: Preschool(Profit Center)  | 1/7/2020 (requested Date) | "new column" = 1/21/2020 (14 days added)

Please let me know if you need additional information.

[bzafft123]

@FreemanZ Its in my example: Example: Preschool(Profit Center)  | 1/7/2020 (requested Date) | "new column" = 1/21/2020 (14 days added

Preschool = add 14 days

Studios = add 30 days

etc.

[FreemanZ · Accepted solution]

hi @bzafft123 

try like:

new column =

SWITCH(

   [Profit Center],

   "Preschool", [Requested Date]+14,

    [Requested Date]+30

)

[bzafft123]

That worked! Thank you so much!

[FreemanZ]

hi @bzafft123 

could provide the value of your expected new column directly? It would be easier for all.