Forum Discussion

tan_thiamhuat's avatar
tan_thiamhuat
Post 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]

 

 

 

  • 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!

     

     

     

2 Replies

  • 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!

     

     

     

    • tan_thiamhuat's avatar
      tan_thiamhuat
      Post Patron

      yes, thank you very much, I just find out the issue too... too many things in PBI, sometime confused over Column or Measure 🙂