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,
I have data coming from SalesForce. BI is not recognising the date as date. when changing the type to date, am left with so many errors, which is quite strange, as the date in the error tab is still formatted in the same way of the correct ones.
I tried few methods that I know, but none worked. I changed the value of / with none and then tried to workout the CALCULATING the Infraction Date but it didn't perform as expected due to the number of characters are not equal in all rows.
Any thoughts to help in a solution?
Solved! Go to Solution.
Looks like you're parsing a "DD/MM/YYYY" format, but your workbook's culture is "MM/DD/YYYY". Luckily, Date.FromText takes an optional culture parameter. Can you try Date.FromText([CreateDate], "en-GB") ?
Hi, i have a semilar problem...
If i want to change text to date, i got some errors which i can't explain to myself. The "error dates" aren't different then the ok once.
Any thoughts to help in a solution? Thanks in advance!
Looks like you're parsing a "DD/MM/YYYY" format, but your workbook's culture is "MM/DD/YYYY". Luckily, Date.FromText takes an optional culture parameter. Can you try Date.FromText([CreateDate], "en-GB") ?
Great! Worked for me as well
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |