Forum Discussion
Solved
formating month
I have created a calendar table, but when i create a month column with a format, it only gives months of January or December. For example i'm getting Feb to June dates returning a month value of Jan...
You don't need to nest any date component formulas inside a FORMAT formula in order to get a single component like month. FORMAT(DateTable[Date], "MMM") should give you what you're looking for.
