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,
The column "souce_published" contain years (year when book are published) but with data type and format as "whole number".
But if i change date type to "date" the "souce_published" instead show dates in june/july 1905.
And if i also change "format" to years (yyyy) it only show the year 1905.
Any idea why this is?
Solved! Go to Solution.
This video, though intended for another topic, illustrates conversion from Number to Date
https://www.youtube.com/watch?v=0sci44xnto0&list=PLApPcvU5-R24K3mbxORV7T3ckVLfDjmHF&index=20
This video, though intended for another topic, illustrates conversion from Number to Date
https://www.youtube.com/watch?v=0sci44xnto0&list=PLApPcvU5-R24K3mbxORV7T3ckVLfDjmHF&index=20
Thank you for your reply. I tried the solution in the video but I get an error message after I convert to text and then try to convert again to Date:
I needed to go inte Edit query and then do the solution from the video - wkred like a charm!
Thanks for the help!
@Johan-MTM It is because a Date is a decimal number and the integer portion is the number of days since December 30th, 1990. So, you would want to do something like DATE([source published],1,1)
User | Count |
---|---|
85 | |
76 | |
72 | |
69 | |
56 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |