Forum Discussion
Date and Time slicer from Calendar table
Microsoft EmployeeHi ni30,
jinma78 already provides wonderful ideas.
Regarding using Unix time, I would suggest adding two cards to show the start and end time in Datetime format, which is easy for us to read.
Regarding using slicers of hours and minutes, please download the demo from the attachment. Don't establish any relationships to the fact table. If you have a large number of measures to create, this idea isn't that smart.
There is still another way that we can create all the possible date time like below.
2019-01-01 00: 00
2019-01-01 00: 01
2019-01-01 00: 02
2019-01-01 00: 03
... ...
Best Regards,
Advocate II- v-jiascu-msft
Hi jinma78,
That's really a problem. It seems we have to add more tables. The main idea of this workaround is capturing the date in a measure.
Best Regards,
- jinma78Hi v-jiascu-msft
Can you provide an example as to what you mean by creating more tables?
Regards- v-jiascu-msft
Hi jinma78,
Two tables for Hour and two tables for Minute. I would suggest creating two time table instead. Please refer to the snapshot below.
startTimeTable = GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 59, 0 ), TIME ( 0, 1, 0 ) )
Best Regards,