Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I have used a switch function to create the following table:
The switch function I have used is the next one:
Solved! Go to 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 ,
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.
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:
@PwrBI01 Great!
Yeah, I just shared the possible workaround using Format DAX. It's nice that you changed it accordingly to your needs.
@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/
Thank you very much for your answer @amitchandak but I would like to do it in a more easy way.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |