Different formats in switch function

[PwrBI01]

Hi guys,

I have used a switch function to create the following table:

The switch function I have used is the next one: 

IF(HASONEVALUE('T_M_Tabla indicadores económicos'[Medida]);SWITCH(VALUES('T_M_Tabla indicadores económicos'[Medida]);"Variación prev. año";[Acumulado dos años previos];"% crecimiento";[Acumulado var %];"Importe medio";[Switch importe medio];"% Var importe medio";[Switch importe medio % var];"Variación a fecha";[Acumulado var]))

Is there a way to change the formats to get a table similar to the next one:

Thanks in advance.

Regards.

[Tahreem24 · Accepted solution]

@PwrBI01 ,

Create a meaure with the below DAX:

MEASURE = IF(HASONEVALUE('T_M_Tabla indicadores económicos'[Medida]);SWITCH(VALUES('T_M_Tabla indicadores económicos'[Medida]);"Variación prev. año";FORMAT([Acumulado dos años previos],"#.### $");"% crecimiento";FORMAT([Acumulado var %],"Percent");"Importe medio";FORMAT([Switch importe medio],"## $");"% Var importe medio";FORMAT([Switch importe medio % var],"Percent");"Variación a fecha";FORMAT([Acumulado var],"#.### $")))

P.S. Just replace the $ sign with Pound sign while writing this dax as per your currency requirement.

[PwrBI01]

Thank you very much @Tahreem24, 

I made some changes (for no decimals in percentages and for get the local format) and it works. The measure I finally used is the next one:

Switch prueba = IF(HASONEVALUE('T_M_Tabla indicadores económicos'[Medida]);SWITCH(VALUES('T_M_Tabla indicadores económicos'[Medida]);"Variación prev. año";FORMAT([Acumulado dos años previos];"#,### €");"% crecimiento";FORMAT([Acumulado var %];"#,### %");"Importe medio";FORMAT([Switch importe medio];"#,### €");"% Var importe medio";FORMAT([Switch importe medio % var];"#,### %");"Variación a fecha";FORMAT([Acumulado var];"#,### €")))

Regards.

[Tahreem24]

@PwrBI01  Great!

Yeah, I just shared the possible workaround using Format DAX. It's nice that you changed it accordingly to your needs.

[amitchandak]

@PwrBI01 , You have to use calculation groups for that as of now

https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

[PwrBI01]

Thank you very much for your answer @amitchandak but I would like to do it in a more easy way.