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.
Estoy utilizando esta medida para determinar la varianza:
@ThePowerBIQueen , tratar como
$ Variación de la venta de Fisher ?
VAR __Store "Fisher"
VAR __SaleEach - CALCULATE(SUM('Table'[SumSale]),filter(all('Table'), 'Table'[Store] - __Store))
devolución
(SUM('Table[SumSale])- __SaleEach )
Todavía no estoy recibiendo el resultado esperado 😞 .. ¿Alguna otra sugerencia?
HI @ThePowerBIQueen,
Proporcione algunos datos ficticios para probar, nos ayudará a probar y modificar las fórmulas de Dax.
Cómo obtener respuesta rápida a su pregunta
saludos
Xiaoxin Sheng
Consulte adjunto para ver el archivo de datos de ejemplo. @parry2k @amitchandak de @v-shex-msft @amitchandak @parry2k
Tienda | $ Vendido | $ Variación vendida de la tienda A | <Resultado esperado |
A | $22,255.18 | $0 | $0 |
B | $6,643.79 | $6,644 | ($15,611.39) |
C | $2,183.03 | $2,183 | ($20,072.15) |
D | $1,749.00 | $1,749 | ($20,506.18) |
E | $2,693.52 | $2,694 | ($19,561.66) |
F | $2,045.77 | $2,046 | ($20,209.41) |
G | $385.81 | $386 | ($21,869.37) |
H | $823.68 | $824 | ($21,431.50) |
@ThePowerBIQueen , por favor encuentre la solución adjunta. Había un espacio en A que remoté. No estoy seguro de que esté allí en sus datos reales
@ThePowerBIQueen ¿No funciona la solución que he proporcionado en otro post? ¿Qué nos falta en esa solución? Aquí está el enlace a otra publicación.
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.
@ThePowerBIQueen aún no está muy claro qué dejó de funcionar en mi solución original. Si puede ser más específico, proporcione el archivo pbix de ejemplo con mi solución y hágamelo saber lo que no está funcionando, le ayudará a recuperar con la respuesta.
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.
Estoy disparando en la oscuridad ahora mismo.
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.
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 |