Add decimals to integer

[Syndicate_Admin]

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

[amitchandak · Accepted solution]

@Syndicate_Admin , Create a new column

[Amount]/100

data type decimal