Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How can I convert this data to a date, in our database I got this timestamp 1557280403. It is from a SQL server.
help wanted
Solved! Go to Solution.
If the timestamp is seconds since 1/1/1970, you can use the use the following function, call it GetDateTimeFromSeconds, then add a step in your query to create a column, calling this function, and passing in your timestamp
I can't take credit for this, got this from another helpful contributor to the community
Hope it helps,
//
// ...This function takes in seconds from epoch and returns a value in datetimezone (UTC)
//
let
Source = (seconds as number) =>
let
Result = #datetimezone(1970, 1, 1, 0, 0, 0, 0, 0) + #duration(0, 0, 0, seconds)
in
Result
in
Source
Hi
Thank you for the reply.
Can to translate it to DAX. (sorry but I am very new in this)
If the timestamp is seconds since 1/1/1970, you can use the use the following function, call it GetDateTimeFromSeconds, then add a step in your query to create a column, calling this function, and passing in your timestamp
I can't take credit for this, got this from another helpful contributor to the community
Hope it helps,
//
// ...This function takes in seconds from epoch and returns a value in datetimezone (UTC)
//
let
Source = (seconds as number) =>
let
Result = #datetimezone(1970, 1, 1, 0, 0, 0, 0, 0) + #duration(0, 0, 0, seconds)
in
Result
in
Source
Hi
I got it works. thanks very much.
Hi
Thank you for the reply.
But can you translate it into DAX. (sorry but I am very new in this)
Hi
Thank you for the reply.
Can to translate it to DAX. (sorry but I am very new in this)
Hi @Anonymous
You can use M to do it, as below
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, 1557280403)
Hope it helps
Mariusz
Hi
I got it works. thanks you very much.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |