The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear all,
I have the following data, e.g. 170,55 (text), and I need to convert it in 170.55 (decimal number).
What I did was:
What I got was 17055, so without the point.
What Am I doing wrong?
Thanks.
Solved! Go to Solution.
it is depending on your format
instead of trying to convert number with this approach, you can use
With the following setting, it will automatically convert number with a comma for the decimal
With this change, I come from
to
It works.
Thanks.
it is depending on your format
instead of trying to convert number with this approach, you can use
With the following setting, it will automatically convert number with a comma for the decimal
With this change, I come from
to