Forum Discussion
Imported date column in Power Query does not display the column as date type in desktop Fields pane
Anonymous , In case you have joined Hire Date with a Date table it will lose auto time Hierarchy.
A date table marked as a date table will not have date hierarchy for the key date column and all dates joining that key will not have a hierarchy too
If the data type is date that should be fine. You can use column from date table
These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045
Anonymous , In case you have joined Hire Date with a Date table it will lose auto time Hierarchy.
A date table marked as a date table will not have date hierarchy for the key date column and all dates joining that key will not have a hierarchy too
If the data type is date that should be fine. You can use column from date table
These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045
Thanks Amitchandak
I inherited a model that I am working on where the date columns had inactive releationships with the Date table that some of the measures created by my predecessor depended on.
When I removed the relationships, the measures were affected, so I had to make another plan.
Simple solution was to make a copy of the 2 columns in Power Query and voila!!
Thanks for your direction on this issue.