Forum Discussion
Datediff .[date] function suggestion
Anonymous , When you mark a date table as date, the date you choose will not have that. The date you join with the date of date table might not have the hierarchy too
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 , I usually prefer not to use .date. There many reasons you can lose the default date hierarchy.
I think if you have only date with no time. No need to worry about that. Also in case of timestamp in date, it should give the correct answer
You use this to create new column or use this calculation
date(year([datetime]),month([datetime]),day([datetime]))
Sorry, I did not understand the "There many reasons you can lose the default date hierarchy." part.
Anonymous , When you mark a date table as date, the date you choose will not have that. The date you join with the date of date table might not have the hierarchy too
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