Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a field which stores unix time time, my filed value contains [{ "start":1529469730821}], I have extracted the number using and the used below calculation to convert it to readable format.
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [epoc]/1000)
But I am geeting below errors, please let me know how can I resolve this issue. Thanks.
Solved! Go to Solution.
Hi @shkabuzar,
FIrst make sure the datatype of epoc column is whole number, then try adding the calculated column.
You can also do this in DAX by using below code:
Timestamp = Table[epoc] / 86400000 + DATE(1970,1,1)
Regards,
Prateek Raina
Hi @shkabuzar,
It would be better to modify the formula like below.
Timestamp = IF(ISBLANK('Table'[epoc]),BLANK(),'Table'[epoc] / 86400000 + DATE(1970,1,1))
If you have solved your problem, could you please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your expected output, so that we can help further investigate on it?
Best Regards,
Cherry
Hi @shkabuzar,
It would be better to modify the formula like below.
Timestamp = IF(ISBLANK('Table'[epoc]),BLANK(),'Table'[epoc] / 86400000 + DATE(1970,1,1))
If you have solved your problem, could you please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your expected output, so that we can help further investigate on it?
Best Regards,
Cherry
Hi @shkabuzar,
FIrst make sure the datatype of epoc column is whole number, then try adding the calculated column.
You can also do this in DAX by using below code:
Timestamp = Table[epoc] / 86400000 + DATE(1970,1,1)
Regards,
Prateek Raina
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |