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.
Hola querida comunidad de Power BI
Espero que lo estén haciendo bien hasta ahora.
Tengo el siguiente problema:
Basado en la satisfacción medida me gustaría dar una calificación (de E-A)
<20 ? E ? > 20 - <50 á D á 50o C á C á > 50 - <-70o B - >70 á A
¿Cómo puedo calcular mi plan para una columna en DAX?
Satisfacción | Grado |
15.50 | E |
20.00 | D |
33.60 | D |
50.00 | C |
64.90 | B |
70.00 | B |
80.50 | A |
Muchas gracias por su contribución.
Que tengas un buen día.
Salud
qwertzuiop
Solved! Go to Solution.
@qwertzuiop intente seguir
Grade =
SWITCH ( TRUE(),
[Satisfcation] > 70, "A",
[Satisfcation] > 50, "B",
[Satisfcation] >= 20, "C",
"E"
)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@qwertzuiop intente seguir
Grade =
SWITCH ( TRUE(),
[Satisfcation] > 70, "A",
[Satisfcation] > 50, "B",
[Satisfcation] >= 20, "C",
"E"
)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hola @parry2k
Desafortunadamente su solución no funciona para mí.
Por el momento estoy tratando de configurar su solución propuesta, pero por el momento no tengo suerte.
... 😞
@qwertzuiop bien que mencionaste que no está funcionando, pero por favor explica lo que no está funcionando? No tengo idea sin que lo expliques. Comparta datos de ejemplo, qué cálculo agregó y cómo los está visualizando y qué no funciona?
Más detalles que proporcione, más rápida será la solución.
Lea este post para obtener su respuesta rápidamente.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hola @parry2k
Disculpe mi ausencia.
Su solución es correcta, pero en lugar de "," necesito usar ";".
Muchas gracias por su apoyo.
Cheers qwertzuiop
😊
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 |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |