Restore the hierarchy of a date field that was lost

[isabelquinonez]

Does anyone know how to restore the date hierarchy of a field that was lost after linking it to another table's field?

Before the relationship with the dimension table called dCalendar, the field had a date hierarchy, but it was lost after the tables were linked.

[isabelquinonez]

Got it, thanks a lot for the help, @vicky_  !

[vicky_ · Accepted solution]

There is no way unless you want to remove the relationship. BTW, the "lost" date heirarchy is an intended feature (not a bug; see here: https://community.fabric.microsoft.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682). I would suggest you use the date heirarchy in the dCalendar table