Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to 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
Remove MONTH function like below:
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