Date Format: Remove Day from the Date

[jambopriti]

I have date like "Monday, December 04, 2023". I need to change the Date like "December 04, 2023" - remove the name of the day.
Please guide how can I achieve this in the report? I do not have access to data model.

may be create a new measure?

Thanks in advance. 

[ExcelMonke · Accepted solution]

Hello,

You can consider using the FORMAT DAX like the following:

Date = 
FORMAT ([Measure],"MMMM/DD/YYYY")

You can check out the following for more combinations:
https://learn.microsoft.com/en-us/dax/format-function-dax 
Of note, this will return your value as a text string, so it won't be helpful for building other measure off the top of it. 

Alternatively, you can also change the format by clicking the field and then "Column tools" (top of your ribbon). Under column tools, you can format the data in the Formatting options to the different date options. Note that this is different than the "structure" options. 

[Kedar_Pande · Accepted solution]

@jambopriti 

Select the date column,

In the format at the top , write "Mmmm dd, yyyy"

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[v-denglli-msft]

Hi @jambopriti ,

May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[saurav_0101 · Accepted solution]

Option 1 (Easy):
Select the date column (of which yiou wish to change the format) and then in Column Tools you will see Format option.

There in the format option you can manually type mmmm dd, yyyy

Option 2 (Slightly Advanced): Using DAX:

Write a DAX to create a new column like below:

I hope this helps, please mark as solution or provide a 'Kudos' if it does.

Thanks.

[Kedar_Pande · Accepted solution]

@jambopriti 

Select the date column,

In the format at the top , write "Mmmm dd, yyyy"

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[ExcelMonke · Accepted solution]

Hello,

You can consider using the FORMAT DAX like the following:

Date = 
FORMAT ([Measure],"MMMM/DD/YYYY")

You can check out the following for more combinations:
https://learn.microsoft.com/en-us/dax/format-function-dax 
Of note, this will return your value as a text string, so it won't be helpful for building other measure off the top of it. 

Alternatively, you can also change the format by clicking the field and then "Column tools" (top of your ribbon). Under column tools, you can format the data in the Formatting options to the different date options. Note that this is different than the "structure" options.