Forum Discussion
Creating DateTime relationship, epoch time
I suspect that it is the time stamp, which is not matching, that are causing the issue, but I actually don't know. I've tried this before where it wasn't an issue. Unfortunatly, I have no access to that report anymore. Could you possibly either share the data or the report?
Thanks in advance,
Martin
Unfortunately I can't share the data nor the report. But the code behind the epoch timestamp is
= Table.AddColumn(#"Removed Columns", "Date", each #datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [TimeStamp])) to get it to human readable mode. I think there shouldn't be anything wrong in this and it should match 100% to DateTime
That was my thought as well. Should probably contact Microsoft about this. I can't re-create your issue.
Niko is your datetime in the date table at at time level?
its better practise to separate out the date and time fields if you using them for analysis?
almost positive that date and time are not matching, even if you do want to keep your date time column create an additional date column without time and see what happens on both sides to test the match to see if it is the datetime causing the issue
