Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
65 | |
60 | |
56 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |