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, chicos
Estoy luchando con un pedazo de DAX.
Tengo 2 mesas. [empleado] y [control de acceso]. relacionado en empID
Necesito una medida tht devuelve cuántas veces ocurre un individuo en la tabla [accescontrol] en un período determinado. returnig 0 si no lo hacen.
Eg
empleado
id de empleado | Nombre |
1 | Jorge |
2 | Lovemore |
3 | Sydey |
4 | Montgomery |
5 | Alecia |
6 | Nadia |
7 | Ramu |
8 | Marcar |
9 | Sean |
10 | Travor |
control de acceso
EmpID | Fecha del evento |
3 | 2021-12-22 |
1 | 2022-01-01 |
5 | 2022-01-02 |
6 | 2022-01-03 |
8 | 2022-01-04 |
9 | 2022-01-05 |
10 | 2022-01-06 |
10 | 2022-01-07 |
5 | 2022-01-08 |
3 | 2022-01-09 |
1 | 2022-01-10 |
1 | 2022-01-11 |
6 | 2022-01-12 |
4 | 2022-01-13 |
9 | 2022-01-14 |
10 | 2022-01-15 |
9 | 2022-01-16 |
5 | 2022-01-17 |
2 | 2022-01-18 |
2 | 2022-01-19 |
9 | 2022-01-20 |
8 | 2022-01-21 |
6 | 2022-01-22 |
6 | 2022-01-23 |
5 | 2022-01-24 |
4 | 2022-01-25 |
3 | 2022-01-26 |
3 | 2022-01-27 |
4 | 2022-01-28 |
2 | 2022-01-29 |
1 | 2022-01-30 |
1 | 2022-01-31 |
filtro 1
2021-12-22 hasta 2022-01-31 | |
Jorge | 5 |
Lovemore | 3 |
Sydey | 4 |
Montgomery | 3 |
Alecia | 4 |
Nadia | 3 |
Ramu | 0 |
Marcar | 2 |
Sean | 4 |
Travor | 3 |
filtro 2
2022-01-01 a 2022-01-10 | |
Jorge | 2 |
Lovemore | 0 |
Sydey | 1 |
Montgomery | 0 |
Alecia | 2 |
Nadia | 1 |
Ramu | 0 |
Marcar | 1 |
Sean | 1 |
Travor | 2 |
filtro 3
| 2022-01-10 hasta 2022-01-25 |
Jorge | 2 |
Lovemore | 2 |
Sydey | 0 |
Montgomery | 2 |
Alecia | 2 |
Nadia | 3 |
Ramu | 0 |
Marcar | 1 |
Sean | 3 |
Travor | 1 |
espero que eso sea lo suficientemente claro?
cualquier idea
gracias a mil
Ian
Solved! Go to Solution.
100%
thnks tanto
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 | |
2 | |
2 | |
2 | |
1 |