Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi Guys. I created a Calender measure however the type icon for this calender is different than the usual one
Below is how I set up the measure and it should be correct since my other database were using this same measure and they working perfectly.
How can I set up calender correctly so I can create hierarchy out of it?
Thanks in advance
Solved! Go to Solution.
It's not a measure (i hope), it's a table. The icon represents a primary key and I think that's what happens when you mark the table as a date table. Reasonably sure you have to create the hierarchy yourself if you do this (create year, month , day columns then create the hierarchy).
If you unmark the table as a date table, the icon will change and the hierarchy will be there (That's me doing this from memory)
Let me know how you get on
It's not a measure (i hope), it's a table. The icon represents a primary key and I think that's what happens when you mark the table as a date table. Reasonably sure you have to create the hierarchy yourself if you do this (create year, month , day columns then create the hierarchy).
If you unmark the table as a date table, the icon will change and the hierarchy will be there (That's me doing this from memory)
Let me know how you get on
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!