Forum Discussion
Creating DateTime relationship, epoch time
Hi, I'm new to powerBI and I just pulled my historical weatherstation data from Azure to powerBI and now I'm trying to figure out how to make DateTime relation. Data was orginally organized by ep...
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.