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.
Hola a todos, me pueden ayudar.....
Tengo una persona con 4 notas (4,2 - 3,7 - 5,5 - 6,8 ) y quiero sacar un promedio solo considerando las 3 mejores notas (4,2 - 5,5 - 6,8) que tiene dejando de lado la nota 3,7 por ser la menor. Que funcion podria servir? . gracias
Solved! Go to Solution.
Hi @Augustuspablo ,
Based on your description, I have created a simple sample:
Please try:
Measure =
var _a = ADDCOLUMNS('Table',"Rank",RANKX('Table',[Column1]))
return AVERAGEX(FILTER(_a,[Rank]<=3),[Column1])
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Augustuspablo ,
Based on your description, I have created a simple sample:
Please try:
Measure =
var _a = ADDCOLUMNS('Table',"Rank",RANKX('Table',[Column1]))
return AVERAGEX(FILTER(_a,[Rank]<=3),[Column1])
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |