Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Community,
i have made a very simple date table using the formula Date Table = calendarauto()
I need to add a month column in and am having trouble with the result as per the below.
Strangely only December and January are being returned. Even for the other months.
Do you know what is wrong with my formula?
thanks,
Russell
Solved! Go to Solution.
try this
Month = FORMAT('Date Table'[Date],"MMMM")
Thanks,
Hi Arul,
thanks for responding. That was the formula I did use, you can see it at the top of the screenshot. I have never encountered this issue before so have no idea where it is coming from.
thanks again
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |