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.
¡Buen día comunidad!
Estaria necesitando obtener el valor maximo entre 2 de 3 conceptos dentro de una columna y que él de menor valor quede en blanco. A su vez, me encontré con la problematica de que cuando ambos son iguales estos se repiten.
Paso ejemplo de como tengo la base:
Y muestro lo que se quiere lograr, idéntico a excel:
Muchas gracias!
Solved! Go to Solution.
Hi @wpretz ,
I am not sure if I understood your question correctly. Is this your desired output?
maximo1 =
VAR tab =
FILTER (
'1- Productividad',
'1- Productividad'[Date] = EARLIER ( '1- Productividad'[Date] )
&& '1- Productividad'[Agrup_Nave] = EARLIER ( '1- Productividad'[Agrup_Nave] )
&& '1- Productividad'[Indicador] <> "Productividad Und"
)
VAR maxvalue =
CALCULATE ( MAX ( '1- Productividad'[Obj_Alcanzado] ), tab )
VAR maxvalue_indicador =
CALCULATE (
MAX ( '1- Productividad'[Indicador] ),
tab,
'1- Productividad'[Obj_Alcanzado] = maxvalue
)
RETURN
IF (
'1- Productividad'[Indicador] IN { "Productividad Lin", "Productividad Ped" },
IF ( '1- Productividad'[Indicador] = maxvalue_indicador, maxvalue ),
BLANK ()
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @wpretz ,
I am not sure if I understood your question correctly. Is this your desired output?
maximo1 =
VAR tab =
FILTER (
'1- Productividad',
'1- Productividad'[Date] = EARLIER ( '1- Productividad'[Date] )
&& '1- Productividad'[Agrup_Nave] = EARLIER ( '1- Productividad'[Agrup_Nave] )
&& '1- Productividad'[Indicador] <> "Productividad Und"
)
VAR maxvalue =
CALCULATE ( MAX ( '1- Productividad'[Obj_Alcanzado] ), tab )
VAR maxvalue_indicador =
CALCULATE (
MAX ( '1- Productividad'[Indicador] ),
tab,
'1- Productividad'[Obj_Alcanzado] = maxvalue
)
RETURN
IF (
'1- Productividad'[Indicador] IN { "Productividad Lin", "Productividad Ped" },
IF ( '1- Productividad'[Indicador] = maxvalue_indicador, maxvalue ),
BLANK ()
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mil gracias! Me sirvió la solucion y el resultado es el esperado!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |