Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SQL DATE Hierarchy

I understand that pulling in dates from SQL messes with the date hierarchy, so I imported my date table (calendarlookup) because we have a funky Fiscal Year and created a date hierarchy using that da...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You can try to sort Month column by MonthNum column.

    Here's the example.

    MonthNum = MONTH([Date])
    Month = FORMAT([Date],"mmm")

    And hierarchy worked.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

You can try to sort Month column by MonthNum column.

Here's the example.

MonthNum = MONTH([Date])
Month = FORMAT([Date],"mmm")

And hierarchy worked.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.