How do i include hour and minutes in Date Hierarchy

[hagosusng]

Hi Everyone,

How do i include Hour and minutes in data hierarchy

 Below is my DateTime

Thank you in advance.

[Mahesh0016 · Accepted solution]

@hagosusng  you can Create Calculate Column 

Time = Format(Table[date],"HH:MM AM/PM")

@hagosusng THANK YOU!!

[ValtteriN · Accepted solution]

Hi,

If you want to create this kind of hierarchu you need to have different columns for each element you want to have in this custom hierarchy. Afterwards, you can right-click your date column and select "create hierachy"

Then select the columns you want to have in your hierarchy and click "add to hierachy":

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Mahesh0016 · Accepted solution]

@hagosusng  you can Create Calculate Column 

Time = Format(Table[date],"HH:MM AM/PM")

@hagosusng THANK YOU!!