How to resolve this..............

[Pratima]

Hi All,

Good Evening !!!

How to get the month name wiith date( Dec 03,Dec 04,Dec 05......Dec31 )  from the calendar date.

Please see the screen shot

Thanks,

Pratima

[v-qiuyu-msft · Accepted solution]

Hi @Pratima,

From your description, it seems you want to display the date type column in the format of month name plus day, right?

It depends on which kind of visual you used to represent data. There are three ways:

1. We can set the data format for the date type column below:

2. If you use charts, like line chart, column chart, you can keep the Continues type enabled for X-axis to get expected format.

In charts you can also enable Date Hierarchy, and keep Concatenate Labels enabled.

3. Create a calculated column to return values in the format of month name plus day like below:

Column = FORMAT(MONTH('Table2'[Date]),"MMM") & " " & DAY('Table2'[Date])

Best Regards,
Qiuyun Yu

[v-qiuyu-msft · Accepted solution]

Hi @Pratima,

From your description, it seems you want to display the date type column in the format of month name plus day, right?

It depends on which kind of visual you used to represent data. There are three ways:

1. We can set the data format for the date type column below:

2. If you use charts, like line chart, column chart, you can keep the Continues type enabled for X-axis to get expected format.

In charts you can also enable Date Hierarchy, and keep Concatenate Labels enabled.

3. Create a calculated column to return values in the format of month name plus day like below:

Column = FORMAT(MONTH('Table2'[Date]),"MMM") & " " & DAY('Table2'[Date])

Best Regards,
Qiuyun Yu

[Pratima · Accepted solution]

Thanks Qiuyun Yu ,i got the expected result.....................by using the following function:

Column = FORMAT(MONTH('Table2'[Date]),"MMM") & " " & DAY('Table2'[Date])

[vanessafvg]

@Pratima do you have a date table?

[Pratima]

Thanks for your valuable time vanessafvg.................

I am having ANY CALENDAR date from that date i am expecting the 

Thanks,

Pratima