Forum Discussion

D_BinduMadhavi's avatar
D_BinduMadhavi
Regular Visitor
1 year ago
Solved

undefined

The FORMAT function for date is returning the date on Dd-MM-YYYY instead of Month when given  Column = FORMAT( CONTRACT[CONTRACT_DT,"DDDD"])
v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
1 year ago

Hi D_BinduMadhavi,

Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to FBergamaschi, for his inputs on this thread.

You are very close,  "DDDD" actually returns the day of week (like Monday), not the month. To show the month name, use "MMMM" (full) or "MMM" (abbreviation).

For example: Month Name = FORMAT(CONTRACT[CONTRACT_DT], "MMMM")

If you also add Month No = MONTH(CONTRACT[CONTRACT_DT]), you can sort Month Name by Month No (Modelling → Sort by column) so months appear Jan–Dec instead of alphabetically. Please also double check that CONTRACT[CONTRACT_DT] is a Date/DateTime column FORMAT expects a real date for best results.

Refer this link for more information: https://learn.microsoft.com/en-us/dax/format-function-dax

Hope this helps. If you have any doubts regarding this, please feel free to ask here. We will be happy to help.
Thank you for using the Microsoft Community Forum.

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
11 months ago

Hi D_BinduMadhavi,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

  • D_BinduMadhavi's avatar
    D_BinduMadhavi
    Regular Visitor
    11 months ago

    v-kpoloju-msft Thanks for checking It started working when I have given the correct the given format.Thanks FBergamaschi 

    • v-kpoloju-msft's avatar
      v-kpoloju-msft
      Community Support
      11 months ago

      Hi D_BinduMadhavi,

      Thanks for the update, and I’m glad to hear it’s working after correcting the format.
      Appreciate you sharing what resolved the issue that will definitely help others in the community facing a similar scenario.

      Thank you.