How to create a new column and display the date format

[xiumi_hou]

Dear all,

I have a date column, it show like : September 10, 2019

                                                        March 20, 2018

I want to create a new column, to use the key word to show:  Sep 10,  2019

                                                                                                  Mar 20, 2018

Thank you 

[SriKandimalla]

Hello @xiumi_hou ,

Review this post, you may apply this for your case

https://community.powerbi.com/t5/Desktop/Date-Format/td-p/120348

Good luck!

[xiumi_hou]

@SriKandimalla Sorry I can not quite understand, can you help me work this out? Thanks

[v-lid-msft · Accepted solution]

Hi @xiumi_hou ,

We can create a calculated column using following formula to meet your requirement:

KeyDate = FORMAT([Date],"MMM dd,YYYY")

But it will be the text format, if you want it as date type but show as  MMM dd,YYYY, we can create another calculated colmun then set it as this format. Or just changet the origin column using following solution.

DateAnotherFormat = [Date]

Enter the Model View, select the column, set the format as custom, use the following code

mmm dd\, yyyy

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[xiumi_hou]

UP