Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Syndicate_Admin
Administrator
Administrator

ERROR DE DAX en el número de formato

Hola chicos,

Tengo este cálculo DAX para formatear la unidad de visualización

SWITCH( TRUE(),
SELECTEDVALUE(v_dim_produit[commodity_name]) = "ELEC", "#,0.00 €/MWh",
FILTERS(v_dim_produit[commodity_name]) in {"Charbon UE", "GAZ Peg", "Gaz TTC"}, "#,0.00 €/Baril",
"#,0.00€")

Y obtengo estos errores para el segundo caso de mi función switch():

ferhat_lyes_0-1699008906812.png

Gracias de antemano 😄

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

Muchas gracias

Syndicate_Admin
Administrator
Administrator

Hola @ferhat_lyes ,

Pruebe lo siguiente

Measure = SWITCH( TRUE(),
SELECTEDVALUE(v_dim_produit[commodity_name]) = "ELEC", "#,0.00 €/MWh",
SELECTEDVALUE(v_dim_produit[commodity_name]) in {"Charbon UE", "GAZ Peg", "Gaz TTC"}, "#,0.00 €/Baril",
"#,0.00€")

Idrissshatila_1-1699009672805.png

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.