Forum Discussion
heli
9 years agoRegular Visitor
Peak througput (count per second)
Hi! I have table that contains the date/time of a signature done by a user since a couple of months. I have duplicated the "Sig Date" column in order to have a dedicated column for the Hour/Minut...
- 9 years ago
Hi,
You have done a good job. The structure of the table is good for hierarchy. We just need create a custom hierarchy.
- Right click on “SigHour”, choose “New hierarchy”;
- Add “SigMinute”, “SigSecond” to “SigHour Hierarchy”;
- Create visual as the picture showed. You can drill down to second now.
Best Regards!
Dale
vanessafvg
Community Champion
9 years agohave you created a separate date table?
i would separate out the dates into a different table. I.e
1. create a date table
2. create a relationship between your sign date and the date in the date table
from the little information you have given that might solve the issue, to create a date table see here
https://www.mattmasson.com/2014/02/creating-a-date-dimension-with-a-power-query-script/