Transform 28 to 0.28 or 120 to 1.20

[eric98]

Hello, hope you're well. 

I'm facing an issue and you may help me. 

I'm trying to convert this integer 28 to decimal value 0.28 or 120 to 1.20

I have an column which contains the two type of value and I don't know how to do it properly in Power BI. 

I've seen this Microsoft article (see this link) but I'm not able to apply it to my case 

[Shreeram04]

Hi @eric98 ,

Just click the column and go to format and change the formatting.

Please find the below screenshot for your reference.

Before:

After:

If this post helps, then please consider Accept it as the solution to help the other members find it more

Thanks,

[eric98]

This is not working. 

I'm just get ".00" after the number and not before.

[Shreeram04 · Accepted solution]

Hi @eric98 

Divide that column value by 100 you can get the result.

please find the below measure and screenshot for your reference.

Column 2 = 'Table (7)'[Days]/100

If this post helps, then please consider Accepting it as the solution to help the other members find more

Thanks,