Forum Discussion

cristianml's avatar
cristianml
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Period / date concatenate to text

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

General Comment
Show and Tell
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

     

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.