Forum Discussion
Currency 2 Decimals
Is there a way to change the 'Auto' option for Currency to '2 Decimals' by default instead of doing it manually each time when creating a measure?
Hi Anonymous ,
I think it's not available for us(uers) to change such a underlying logic ,which is designed by developer.
You may use the following formula to directly change the format:
Format = CONVERT( FORMAT(SUM('Table'[Value]),"#.00") ,CURRENCY)Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I think it's not available for us(uers) to change such a underlying logic ,which is designed by developer.
You may use the following formula to directly change the format:
Format = CONVERT( FORMAT(SUM('Table'[Value]),"#.00") ,CURRENCY)
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.