topic Re: Format function with Switch in DAX Commands and Tips

Format function with Switch

ThaysEloi — Fri, 15 Jul 2022 13:52:42 GMT

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?

Re: Format function with Switch

technolog — Fri, 15 Jul 2022 14:29:23 GMT

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

Re: Format function with Switch

ThaysEloi1 — Fri, 15 Jul 2022 16:08:03 GMT

I tried and the DAX reports error.

Re: Format function with Switch

technolog — Fri, 15 Jul 2022 17:05:44 GMT

Could you send a screenshots?

Re: Format function with Switch

Anonymous — Tue, 19 Jul 2022 03:04:59 GMT

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