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.
I´m working with report and I have a problem with the data in a column that refers to a date.
Here is a sample of the data:
When trying to convert to a date, this the error:
I have tried different changes in the format with no results.
Thanks,
Solved! Go to Solution.
Are you in a locale that uses yyyyddMM format? You can convert it to Text type and use Date.FromText with the Format option like this.
Date.FromText([Date], [Format = "yyyyddMM"])
Pat
Are you in a locale that uses yyyyddMM format? You can convert it to Text type and use Date.FromText with the Format option like this.
Date.FromText([Date], [Format = "yyyyddMM"])
Pat
Yes , it works.
Thanks,
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |