Period / date concatenate to text

[cristianml]

Hi, 

I need to concatenate 2 columns with the Format YYYY-MM mmm'yy

I tried the following but it doesn't work :

YYYY-MM mmm'yy = CONCATENATE(Period[Year-Month] & " - " ,Period[Period])

Any idea ?

Thanks !!

[v-yalanwu-msft · Accepted solution]

Hi, @cristianml ;

Please try to modify it:

YYYY-MM mmm'yy2 = FORMAT([Year-Month],"yyyy-mm")&"-"&FORMAT([Period],"mmm yy")

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RandyPgh]

Try putting your column name in brackets. The apostrophe is a special character and might be confusing the editor, although it ought to throw an error.