How to remove zeros from after decimal point

[harib]

Hi,

I would like to remove zeros from after decimal point like below output.  is it possible to remove and get the out put eactly like below image.

Thanks in advance

[VasTg]

@harib 

Use Custom format in model tab.

If it helps, mark it as solution

Kudos are nice too

[harib]

@VasTg 

0 is missing . Let's say if it is 0.25 when we format it's giving .25 only. 0.25 has to come

[VasTg · Accepted solution]

@harib 

Change the format to #,###,##0.##

[FrailHumanity]

Could you please explain the logic?

[harib]

@VasTg 

Yes. It's working perfectly. Thanks a lot @VasTg . 😊

[Tad17]

Hey @harib 

@Greg_Deckler  sovled this problem in this thread: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Removing-zeros-from-after-decimal-point/td-p/...

If this helps please kudo.

If this solves your problem please accept it as a solution.

(And don't forget to kudo Greg's solution in the linked thread)

[harib]

@Tad17 

I have tried but replace with blank not acccepting. 

[Tad17]

Hey @harib 

Try converting the column to text in the modelling tab to see if the replace will work.