Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
Im having an issue, i have a large dataset where the dates currently have the excel serial format. Is it possible to format this column to proper dateformat, perferably in the query?
It might also be relevant to say that the sourcefile is a .txt
Serial format/ Normal format
Br,
Johannes
Solved! Go to Solution.
In the Query Editor right click the Serial Date column header and Change Data Type to Date.
in Excel 1st date is 01-01-1900, so you could just add nr of days since then
e.g. use this code for new column
#date(1900,1,1)+#duration([Serial Date]-2,0,0,0)
EDIT Sean's answer is way simpler, I'd go with it
in Excel 1st date is 01-01-1900, so you could just add nr of days since then
e.g. use this code for new column
#date(1900,1,1)+#duration([Serial Date]-2,0,0,0)
EDIT Sean's answer is way simpler, I'd go with it
Both ways work, i managed to figure out ur proposed way before i had a chance to read the responses her 😛
Thanks for the assistance,
J
In the Query Editor right click the Serial Date column header and Change Data Type to Date.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |