Format function with Switch

[ThaysEloi]

I've following DAX: 

EBITDA CLP =

IF(ISINSCOPE(Aux_EBITDA[Codigo Topico ]),

SWITCH(SELECTEDVALUE(Aux_EBITDA[Codigo Topico ]),

101, [Revenues],

102, [Personnel EB],

103, _Medidas_EBITDA[Maintenance EB],

104, [Operational EB],

105, [Other expenses EB],

106, _Medidas_EBITDA[Total Expenses],

107, [CHILE EBITDA],

108, [Net Margin, Variance],

109, [Revenues MP],

110, _Medidas_EBITDA[Expenses MP],

111, _Medidas_EBITDA[SA MP EBITDA],

112, [Gross Margin, Variance MP],

113, [Revenues AC],

114, _Medidas_EBITDA[Expenses AC],

115, _Medidas_EBITDA[SA ACID EBITDA],

116, [Gross Margin, Variance AC],

117, [Revenues MEJ],

118, [Expenses MEJ],

119, _Medidas_EBITDA[SA MEJ EBITDA],

120, [Gross Margin, Variance MEJ],

121, [Revenues GLP],

122, _Medidas_EBITDA[Expenses GLP],

123, [GLP GAS EBITDA],

124, [Gross Margin, Variance GLP],

125, [Overhead])

)

Measures in bold must be in percentage. How do I do this within the SWITCH?

[technolog]

Hi!

You can use FORMAT function:

FORMAT( 12345.67, "Percent")

like:

120, FORMAT( [Gross Margin, Variance MEJ], "Percent") ,

Documentation: https://docs.microsoft.com/ru-ru/dax/format-function-dax

[ThaysEloi1]

I tried and the DAX reports error.

[Anonymous]

Hi @ThaysEloi 

Please refer to this post for the solution:

Solved: FORMAT Function error

Note the data type of the returned result.

If this does not work, please consider providing an error message or a sample file without private data.

How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[technolog]

Could you send a screenshots?