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 am having the below timestamp
I tried the below formula
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0,[create_date]/1000)
I am getting the below error
Can anyone advise me how to do this?
Solved! Go to Solution.
Hi @bourne2000 ,
Accroding to the error message, you will need to change the data type of [create_date] to whole number then use the formula.
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [create_date]/1000)
Best Regards,
Jay
Hi @bourne2000 ,
Accroding to the error message, you will need to change the data type of [create_date] to whole number then use the formula.
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [create_date]/1000)
Best Regards,
Jay
Hello Jay,
Thanks for your post. I try the solution, and it works. But, why 1970? The date since not appropriate...
@PC2790 I tried to convert into date. Getting the below error
DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
1652810074075
What is the source of your data?
can you check if it is fine at the source? Also, is the Locale of your source and Power BI dekstop same?
Hey @bourne2000 ,
As per te error, it is not letting a text field to be divided by 1000. So - [create_date]/1000 woun't work.
Did you try converting the datatype by selecting the ABC adjacent to column name and selecting date there?
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 |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |