Forum Discussion

tan_thiamhuat's avatar
tan_thiamhuat
Icon for Post Patron rankPost Patron
1 year ago
Solved

Date Hierachy

why is my BookTime without Date Hierachy, when it is of Date type? I do not want to manually create it.   and it mentions it cannot find name [BookTime]      
  • suparnababu8's avatar
    1 year ago

    Hi tan_thiamhuat 

     

    It's throwing error bcz, you are creating a measure instead of Calculated column. I replicated yoru scenario. getting the same error.

    Now You can click on  New column

    Then you can enter your DAX code and now there is no error

    Now I have column created as Year. pls have a look below

     

    Hope you are clear now.

     

    Pls let me know if it works

     

    Thank you!

     

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

    Proud to be a Super User!