topic Re: undefined in DAX Commands and Tips

undefined

D_BinduMadhavi — Wed, 20 Aug 2025 16:54:03 GMT

The FORMAT function for date is returning the date on Dd-MM-YYYY instead of Month when given

Column = FORMAT( CONTRACT[CONTRACT_DT,"DDDD"])

Re: undefined

FBergamaschi — Wed, 20 Aug 2025 19:10:30 GMT

The syntax you mention

Column = FORMAT( CONTRACT[CONTRACT_DT,"DDDD"])

Cannot work

In case

Column = FORMAT( CONTRACT[CONTRACT_DT],"DDDD")

But you want the month so

Column = FORMAT( CONTRACT[CONTRACT_DT,"mm"])

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Re: undefined

D_BinduMadhavi — Thu, 21 Aug 2025 06:14:29 GMT

FBergamaschi ,Thank you very much for your reply. I have tried the above format as well, its returing the exact date in the new column instead of returning month when given MM and day when DDDD is given....! Is there any settings that I can do in my BI tool for my FORMAT function to work properly?

Re: undefined

FBergamaschi — Thu, 21 Aug 2025 08:50:01 GMT

Can you please share the pbix via some cloud service and post the link here (or in a private message) so I check the issue?

Please mention me or I los the thread

Thanks

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Re: undefined

v-kpoloju-msft — Fri, 22 Aug 2025 05:30:01 GMT

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.

Re: undefined

v-kpoloju-msft — Thu, 28 Aug 2025 12:06:54 GMT

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.

Re: undefined

D_BinduMadhavi — Thu, 28 Aug 2025 14:21:30 GMT

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

Re: undefined

v-kpoloju-msft — Thu, 28 Aug 2025 14:45:30 GMT

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.

Re: undefined

FBergamaschi — Thu, 28 Aug 2025 15:27:12 GMT

Hi D_BinduMadhavi , if you had a solution, please mark it as such

Thanks!

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI