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 a todos,
Quiero crear un gráfico de área acumulativo basado en el nombre del mes en lugar del número de mes. Actualmente esta es mi medida de trabajo, pero ¿cómo puedo hacer que funcione usando el nombre del mes en su lugar? No se verá bien si uso el número de mes como eje x de mi gráfico de área.
Solved! Go to Solution.
@beekee también puede agregar la columna de nombre de mes en la función ALL
Cumulative =
CALCULATE(
SUM(Table1[Value]),
FILTER(
ALL(
Table1[Month Num],
Table[Month Name]
),
Table1[Month Num] <= MAX(Table1[Month Num])
)
)
Apreciaría Kudos 🙂 si mi solución me ayudara. Pregunte cualquier cosa Power BI. Reserva una cita para una consulta gratuita en https://www.perytus.com
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
Pruebe este enfoque
Valores: SUM(Table1[Value])
Acumulativo: CALCULATE([Values],DATESYTD(Calendar[Date]))
Espero que esto ayude.
@beekee también puede agregar la columna de nombre de mes en la función ALL
Cumulative =
CALCULATE(
SUM(Table1[Value]),
FILTER(
ALL(
Table1[Month Num],
Table[Month Name]
),
Table1[Month Num] <= MAX(Table1[Month Num])
)
)
Apreciaría Kudos 🙂 si mi solución me ayudara. Pregunte cualquier cosa Power BI. Reserva una cita para una consulta gratuita en https://www.perytus.com
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 |