Forum Discussion
Solved
Date Hierarchy Not Available for Calculated Column
I have 2 columns in my data. CompletedVisitDate and ScheduledVisitDate. These both meet the status of Completed or Scheduled. To account for them together, I created a new column: MaxActionDate = ...
comish4lif2 , Ant date joined with date table marked as date table will not have hierarchy, You can create custom hierarchy and use
create a new hierarchy
https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY
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
Hi,
Create calculated column formulas to extract Day, Month, Month name and Year in the Calendar Table. To your visuals/in your measures, refer to the fields from the Calendar Table.