Forum Discussion
Solved
Date Hierarchy in Direct Query
Is there a solution to getting the date hierarchy in Direct Query? I noted some postings saying it was not available but they are from 2016. I'm hoping there has been a solution devised since then....
Hi iowakrz ,
Currently, the built-in date hierarchy is not yet available when using DirectQuery mode. You could click to upvote this idea or add your own comments.
As a workaround, you could create a custom date hierarchy manually. Please create [Year], [Quarter], [Month], [Day] columns first, right-click the original Date column and choose 'New Hierarchy', then, drag [Year], [Quarter], [Month], [Day] columns to place them under [Date] column.
Best regards,
Yuliana Gu
