Format Function using Switch Statement

[rbalza]

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")

[amitchandak · Accepted solution]

@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