Forum Discussion
Date Format: Remove Day from the Date
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.
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.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 LinkedInOption 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.
4 Replies
- Kedar_PandeSuper User
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 - ExcelMonkeImpactful Individual
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. - saurav_0101Frequent Visitor
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.
- AnonymousNot applicable
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.