Forum Discussion

jambopriti's avatar
jambopriti
Helper I
1 year ago
Solved

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. 

  • 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.

4 Replies

  • 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's avatar
    ExcelMonke
    Impactful 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_0101's avatar
    saurav_0101
    Frequent 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.

  • Anonymous's avatar
    Anonymous
    Not 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.