Forum Discussion
Fcoatis
Post Patron
Post PatronNumber.FromText syntax
Hi, I have a custom column that is returning exactly what I want. That is, if a number is in "en-Us" use locale otherwise regional: = Table.AddColumn(RemCol3, "Custom", each try Number.Fr...
Hi Fcoatis ,
Based on your description, you can modify your M-query a little.
= Table.AddColumn(RemCol3, "Custom", each try Number.FromText([Custom1], "en-US") otherwise Number.FromText([Custom1]), type number)You need to define your data type of this column, or the default type is "any".
Here is my test result.
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Fcoatis ,
Based on your description, you can modify your M-query a little.
= Table.AddColumn(RemCol3, "Custom", each try Number.FromText([Custom1], "en-US") otherwise Number.FromText([Custom1]), type number)
You need to define your data type of this column, or the default type is "any".
Here is my test result.
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.