Good afternoon. I have a presentation in 1.5 hours and something which I thought would be so simple is not working. I have a FACT table where I have Date and Time as separate columns. I then created a Times table using the query on this thread HERE, specifically (TimeQuery.txt (2.4 KB) )
When I came to do the one to many relationship, that worked fine:
However when I attempt to see if my times are actually matching up, none of them match at all:
Then I took a table for each of my Times, and I found the exact same value in both and copied and pasted into notepad, they look exactly the same:
Sat Dec 30 1899 00:26:08 GMT+0130 (South Africa Standard Time)
Sat Dec 30 1899 00:26:08 GMT+0130 (South Africa Standard Time)
For good measure, in Power Query for each of the time columns I ensured they were visually in the same format (data Type = Time), and then also Transform > Time > “Time only”.
Still no matter what I do, my times aren’t mapping between my Times table and my AuditEvents table. Please could somebody help me urgently?