Forum Discussion
prabavathym
1 year agoHelper II
Slicer Not Filtering Table Visual
Hi all, I have two tables: Date Table: Date column ranges from 08/01/2024 12:00:00 AM to 12/04/2024 12:00:00 AM. Log Table: StreamingStartTimeUTC column with the same range and format. I’ve est...
Idrissshatila
1 year agoSuper User
Hello prabavathym ,
What I think that the date and time should be seperated and the dim date should be date and the date column should be date as well in the fact.
if you want to filter by time, then you need to have a dim time table that links to the seperated time field.
- prabavathym1 year agoHelper II
Thank you for your response! Could you kindly clarify how to proceed with separating the Date and Time fields in the suggested way?
I already have distinct DateTime columns in my tables, but I’m unsure how to set up the relationships and create a Dim Time Table.