Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hola a todos,
Estoy intentando generar la columna de clasificación en la siguiente tabla
mes | Columna1 | cliente | ventas | Ventas mensuales de clientes | rango |
1-Ene | ene | Cliente1 | 20,714 | 73,908 | 2 |
2-Ene | ene | Cliente1 | 27,793 | 73,908 | 2 |
3-Ene | ene | Cliente1 | 25,401 | 73,908 | 2 |
4-Ene | ene | Cliente2 | 25,445 | 78,971 | 1 |
5-Ene | ene | Cliente2 | 26,388 | 78,971 | 1 |
6-Ene | ene | Cliente2 | 27,138 | 78,971 | 1 |
7-Ene | ene | Cliente3 | 14,017 | 73,435 | 3 |
8-Ene | ene | Cliente3 | 29,776 | 73,435 | 3 |
9-Ene | ene | Cliente3 | 29,642 | 73,435 | 3 |
1-Feb | Feb | Cliente1 | 21,175 | 55,023 | 3 |
2-Feb | Feb | Cliente1 | 10,873 | 55,023 | 3 |
3-Feb | Feb | Cliente1 | 22,975 | 55,023 | 3 |
4-Feb | Feb | Cliente2 | 26,087 | 57,076 | 2 |
5-Feb | Feb | Cliente2 | 20,605 | 57,076 | 2 |
6-Feb | Feb | Cliente2 | 10,384 | 57,076 | 2 |
7-Feb | Feb | Cliente3 | 29,730 | 71,856 | 1 |
8-Feb | Feb | Cliente3 | 12,634 | 71,856 | 1 |
9-Feb | Feb | Cliente3 | 29,492 | 71,856 | 1 |
1-Mar | estropear | Cliente1 | 24,603 | 62,713 | 2 |
2-Mar | estropear | Cliente1 | 10,636 | 62,713 | 2 |
3-Mar | estropear | Cliente1 | 27,474 | 62,713 | 2 |
4-Mar | estropear | Cliente2 | 24,958 | 61,091 | 3 |
5-Mar | estropear | Cliente2 | 15,683 | 61,091 | 3 |
6-Mar | estropear | Cliente2 | 20,450 | 61,091 | 3 |
7-Mar | estropear | Cliente3 | 18,982 | 72,661 | 1 |
8-Mar | estropear | Cliente3 | 24,464 | 72,661 | 1 |
9-Mar | estropear | Cliente3 | 29,215 | 72,661 | 1 |
El rango aquí se describiría como rango de las ventas totales del cliente por mes dado en un mes determinado
Solved! Go to Solution.