Forum Discussion
Format Function using Switch Statement
Hello PowerBi Heroes,
Is there a way to remove the decimal point on the format function? I am using switch statement with different measures and formatting. See below measure for reference. Thanks in advance!
EBIT APS Normalised = FORMAT([Revenue] * [EBIT% Revenue],"Currency")
rbalza , I think a currency will have a decimal place. choose a format like "###,###"
Refer this page for various format
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
Also try to use the property UI, in place of custom format, when possible
1 Reply
rbalza , I think a currency will have a decimal place. choose a format like "###,###"
Refer this page for various format
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
Also try to use the property UI, in place of custom format, when possible