Forum Discussion
date hierarchy missing
Anonymous
Make sure you create Date table using calendar command
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
amitchandak SivaMani I got error "date column can't have gaps in dates"
any idea how to solve that?
Community SupportHi Anonymous ,
It's impossible to sue "date hierarchy" if you use "Direct Query" connection model.
And as tested, the date hierarchy cannot be displayed if this column is linked to other column.
The impact of table relationships on date hierarchies
1:1
1:*
(1: the date can use hierarchy; *: can't)
*:*
Smmarize: only one side of the date can use the date hierarchy.
So you may need to modify your table model.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.