Manually creating a date hierarchy (same as "auto date/time" without the associated problems)

[Anonymous]

Common advice is to avoid "auto date/time" because it can bloat a model

However, afaik it's not commonly known how to manually replicate what the automatic feature does, so that you get the same outcome (a date hierarchy) but selectively for the data fields you want

It's hard to figure out but easy to do with Tabular Editor, and I wondered whether it would be useful for other people - in which case, I'd write it up

Let me know in the comments / thumbs up and I'll follow up if so

[amitchandak]

@Anonymous , I think for that you have to create a date column like year, month qtr, and create a custom hierarchy. Based on what I got 

Year = Year([Date])

Month = Month([Date])

Day = Day([Date])

refer how to create

Custom Hierarchy
https://stoneridgesoftware.com/creating-hierarchies-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

[Anonymous · Accepted solution]

Just to clarify for anyone reading, I'm offering to show how to create a date hierarchy for any date field, not asking for help 

[v-kelly-msft]

Hi  @Anonymous,

Thanks for your kindly sharing,forum is  a place where we seek help, so it would be appreciated if you could post some useful examples and then mark the reply as answered  to let more people find the solutions here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!