Create New column based on Given text and Current Month

[SJHALANI]

Hi,

I have a table which has a column 'PO Projections'. I want to create a new column which has values basis the values in 'PO Projections' column.  The values in new column corresponding to 'PO Projections' are given below:

PO Projections	Logic for New column	Example (What New column should say)
One cycle budget	Current Month - 1	Apr'23
Two cycles budget	Current Month	May'23
Three cycles budget	Current Month + 1	Jun'23

Can anyone help me with the above. Really appreciate all the help in advance! Thank you!

[Ajendra]

Hey,

I hope this message finds you well!

Pls try this.

in case of you find this reply as solution mark my reply as resolved.

Thanks!!