Forum Discussion
Syndicate_Admin
4 years agoAdministrator
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
1 Reply
- amitchandakSuper User