Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Buenos días,
Necesito ayuda para sacar la siguiente información, con los datos que muestro a continuación:
Tengo la información de usuarios por año y mes, con su respectiva ubicación. Tal como se muestra en la imagen, ahora, mi requerimiento es identificar cuales de esos usuarios cambiaron de ubicación a traves del tiempo. Pero no se como ir llamando por "NIU" y a la vez vaya corriendo años y meses y verifique que la ubicación sea la misma.
Solved! Go to Solution.
Hi @Anonymous ,
Is this what you want to achieve?
If so, please try this measure.
Measure =
VAR _count =
CALCULATE(
DISTINCTCOUNT('Table'[Location]),FILTER(ALL('Table'),'Table'[NIU]=MAX('Table'[NIU])))
VAR _status =
IF(_count<>1,"Different","Same")
RETURN
_status
Please check the 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
Hi @Anonymous ,
Is this what you want to achieve?
If so, please try this measure.
Measure =
VAR _count =
CALCULATE(
DISTINCTCOUNT('Table'[Location]),FILTER(ALL('Table'),'Table'[NIU]=MAX('Table'[NIU])))
VAR _status =
IF(_count<>1,"Different","Same")
RETURN
_status
Please check the 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