Forum Discussion
Date Format: Remove Day from the Date
- 1 year ago
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. - 1 year ago
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 - 1 year ago
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.
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.