Forum Discussion

jambopriti's avatar
jambopriti
Icon for Helper I rankHelper 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...
  • ExcelMonke's avatar
    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. 

  • Kedar_Pande's avatar
    1 year ago

    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

     

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