topic Re: Format Function using Switch Statement in DAX Commands and Tips

Format Function using Switch Statement

rbalza — Wed, 12 May 2021 13:10:13 GMT

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

Re: Format Function using Switch Statement

amitchandak — Wed, 12 May 2021 14:17:47 GMT

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