Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Buenas Tardes comunidad
Me pueden ayudar para calcular el promedio total de cada semana, por cada producto en una medida DAX de los siguientes datos
Semana | PRODUCTO | % Total Promedio |
1 | PRODUCTO 1 | 93.75 |
1 | PRODUCTO 2 | 93.75 |
1 | PRODUCTO 3 | 93.75 |
1 | PRODUCTO 4 | 93.75 |
1 | PRODUCTO 5 | 87.5 |
1 | PRODUCTO 6 | 93.75 |
1 | PRODUCTO 7 | 87.5 |
1 | PRODUCTO 8 | 75 |
1 | PRODUCTO 8 | 93.75 |
1 | PRODUCTO 7 | 93.75 |
1 | PRODUCTO 2 | 93.75 |
1 | PRODUCTO 5 | 93.75 |
1 | PRODUCTO 9 | 93.75 |
1 | PRODUCTO 4 | 100 |
2 | PRODUCTO 10 | 93.75 |
2 | PRODUCTO 8 | 87.5 |
2 | PRODUCTO 1 | 50 |
2 | PRODUCTO 6 | 93.75 |
2 | PRODUCTO 7 | 87.5 |
2 | PRODUCTO 11 | 93.75 |
2 | PRODUCTO 5 | 87.5 |
2 | PRODUCTO 8 | 87.5 |
2 | PRODUCTO 3 | 50 |
2 | PRODUCTO 4 | 87.5 |
2 | PRODUCTO 9 | 93.75 |
2 | PRODUCTO 1 | 87.5 |
3 | PRODUCTO 5 | 100 |
3 | PRODUCTO 3 | 87.5 |
3 | PRODUCTO 4 | 93.75 |
3 | PRODUCTO 6 | 93.75 |
3 | PRODUCTO 7 | 87.5 |
3 | PRODUCTO 2 | 93.75 |
3 | PRODUCTO 6 | 87.5 |
3 | PRODUCTO 8 | 93.75 |
3 | PRODUCTO 1 | 93.75 |
3 | PRODUCTO 7 | 87.5 |
3 | PRODUCTO 8 | 93.75 |
3 | PRODUCTO 11 | 25 |
3 | PRODUCTO 5 | 93.75 |
4 | PRODUCTO 5 | 93.75 |
4 | PRODUCTO 8 | 87.5 |
4 | PRODUCTO 2 | 93.75 |
4 | PRODUCTO 1 | 93.75 |
4 | PRODUCTO 6 | 50 |
4 | PRODUCTO 8 | 93.75 |
4 | PRODUCTO 4 | 87.5 |
4 | PRODUCTO 7 | 87.5 |
4 | PRODUCTO 8 | 87.5 |
4 | PRODUCTO 1 | 93.75 |
4 | PRODUCTO 3 | 87.5 |
4 | PRODUCTO 9 | 81.25 |
4 | PRODUCTO 6 | 93.75 |
5 | PRODUCTO 5 | 93.75 |
5 | PRODUCTO 4 | 100 |
5 | PRODUCTO 6 | 87.5 |
5 | PRODUCTO 2 | 93.75 |
5 | PRODUCTO 3 | 93.75 |
5 | PRODUCTO 1 | 87.5 |
5 | PRODUCTO 7 | 100 |
5 | PRODUCTO 8 | 93.75 |
5 | PRODUCTO 1 | 93.75 |
@JulianDavidMM can you ask the question in English?
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.
Good afternoon community
You can help me to calculate the total average of each week, for each product in a DAX measure of the following data
Hi @JulianDavidMM ,
Please check the attached pbix file.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
I share the report if you can review it, thanks.
https://www.dropbox.com/scl/fi/0hqhmx93a1t6utvbdstag/Informe.pbix?rlkey=hp4ebel48a34xdgdaqbl1w2ux&dl...
Hi @JulianDavidMM ,
Please refer to the attached pbix file:
If this is not the output you expect, please consider modeling the expected output with a table and taking a screenshot, that would be helpful thanks.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hola @v-cgao-msft , Muchas gracias por tu ayuda, no sé si realmente no me hago entender muy bien, pero necesito calcular la media de la semana 1, semana 2, semana 3, etc... y ese promedio de cada semana, y tomar un promedio total del resultado de cada semana. Adjunto 2 ejemplos de cómo debe ser en power bi, pido disculpas si no me quedó claro, lo que necesito es el promedio de mi columna "Line"
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |