Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Add decimals to integer

Dear

I can't visualize the decimals in a table, it shows me the field as an integer (Surely the point separating the decimals I take as thousands).

I have 2 tables with different formats: In one the decimals separated with commas "," but in another I have the decimals with periods "." and that is why the Power BI takes the amount without decimals (It shows it as an integer).

For example, in the AMOUNT column:
The number appears integer: "45756050"

I need it to appear: "457560,50"

Changing the numeric format to text in Power Query doesn't show me the decimal point either.

Is there a possibility to add the decimal symbol "," before the last 2 numbers?

I appreciate your help.


Best regards

Martin