Create New column based on Given text and Current Month

Question

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.&nbsp; The values in new column corresponding to 'PO Projections' are given below:&nbsp;PO Projections&nbsp;Logic for New columnExample (What New column should say)&nbsp;One cycle budget&nbsp;Current Month - 1Apr'23&nbsp;Two cycles budget&nbsp;Current MonthMay'23&nbsp;Three cycles budget&nbsp;Current Month + 1Jun'23Can anyone help me with the above. Really appreciate all the help in advance! Thank you!

ajendra · Answer

Hey,I hope this message finds you well!&nbsp;Pls try this.in case of you find this reply as solution mark my reply as resolved.&nbsp;Thanks!!

Forum Discussion

Create New column based on Given text and Current Month

1 Reply

Related content

Create columns group

Creating a date column

Creating a custom column

Appending columns and creating new column of old column headers

unpivoting columns and creating datetime column

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