Create New column based on Given text and Current Month

SJHALANI — Tue, 09 May 2023 17:13:34 GMT

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!

Re: Create New column based on Given text and Current Month

Ajendra — Tue, 09 May 2023 19:05:10 GMT

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!!

topic Create New column based on Given text and Current Month in DAX Commands and Tips

Create New column based on Given text and Current Month

Re: Create New column based on Given text and Current Month