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 All,
I'm wondering what went wrong with "date.fromtext".
https://msdn.microsoft.com/en-us/query-bi/m/date-fromtext
I tried it in Excel 2016 and PowerBI Desktop April update
On my end, I tried,
Date.FromText("2010-02-19") equals Date,yyyy-MM-dd
and
Date.FromText("2010-02-19") equals Date,yyyy-MM-dd
and both showed "Token Eof expected" and the error is on 'equals'
Will anyone be able to advice what went wrong?
Many Thanks
Solved! Go to Solution.
Hi Rookarumba,
Date.From("2010-02-19") is a function, "Date.FromText("2010-02-19") equals Date,yyyy-MM-dd" from MSDN is description which explain that you can achieve a date type result when use Date.From() function.
Regards,
Jimmy Tao
Hi Rookarumba,
Date.From("2010-02-19") is a function, "Date.FromText("2010-02-19") equals Date,yyyy-MM-dd" from MSDN is description which explain that you can achieve a date type result when use Date.From() function.
Regards,
Jimmy Tao
Thanks, that work 🙂
I think date.FromText doesn't work in power bi, try below:-
Column = Format("2010-02-19","Short Date")
https://msdn.microsoft.com/en-us/query-bi/dax/format-function-dax
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 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |