Forum Discussion
Format function with Switch
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?
4 Replies
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
I tried and the DAX reports error.
Could you send a screenshots?
