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,
Any idea how to fix the error? I had this custom column for calculating FY working for some time, and now it stopped working. It gives out the error that "We couldn't convert to Number" in the final step. Any help would be appreciated.
Thank you!
Solved! Go to Solution.
There is data that cannot be converted to a number. "abc" would return that error. You have probably two options.
so try this:
if (try Number.FromText([Field]) otherwise 0) > 9 then.....
If [Field] has "100" in it, then it will evaluate to true, it is > 9. If it has "abc" it will return 0, and false. So alter based on your logic needs.
If you want to see why there are values that cannot be converted, create a copy of this query and change field to a number type, then filter on the home ribbon "KEEP ROWS, KEEP ERRORS" and it will show you the records that have the bad data.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe error maybe data related (a transformation failed, a calculation overflowed, etc), or can be data size related (server gave up returning data, out of memory, driver failed, quota reach, etc)
Regards,
J Wick
It worked! looks like there was bad data coming in.
Thank you!
There is data that cannot be converted to a number. "abc" would return that error. You have probably two options.
so try this:
if (try Number.FromText([Field]) otherwise 0) > 9 then.....
If [Field] has "100" in it, then it will evaluate to true, it is > 9. If it has "abc" it will return 0, and false. So alter based on your logic needs.
If you want to see why there are values that cannot be converted, create a copy of this query and change field to a number type, then filter on the home ribbon "KEEP ROWS, KEEP ERRORS" and it will show you the records that have the bad data.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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.