FORMAT formula for calculated column, not working properly

[caf_fdc]

Hi, I'm new here. I'm having troubles with the FORMAT function:

- I have a daily Date Table, calculated from CALENDARAUTO function.

- I'm using this formula create a calculated column to get an abbreviated month name: 

MMM* =

FORMAT(

    MONTH('Date'[Date]),

    "MMM"

)

- The result does not make any sense, all January dates returns "Dec", and all other months returns "Jan".

- When I try to extract the month number with Month = MONTH('Date'[Date]), everything works fine.

I have always use the first formula and this is the first time I have this problem, and actually the same formula works fine in other report. I have tried to create a new report and the result is the same.

Help please.

caf_fdc

[Bibiano_Geraldo]

Remove MONTH function like below:

MMM* =

FORMAT(

    'Date'[Date],

    "MMM"

)

If this work, please mark this answer as solution

[PijushRoy · Accepted solution]

Hi @caf_fdc 

Use this DAX

MMM =
FORMAT(
    'Date'[Date],
    "MMM"
)

Or

MMM FUll name =
FORMAT(
    'Date'[Date],
    "MMMM"
)

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin