Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone! And thanks for reading my message!
I've read several posts both in this and in another forums, but unfortunately I couldn't figure how to get what I want.
I have this query called "Llamados" where I register phone calls.
CodigoLlamado | Fecha |
63564 | 02/01/2017 |
63540 | 02/01/2017 |
63590 | 15/01/2017 |
63250 | 16/01/2017 |
63971 | 07/01/2017 |
63782 | 30/01/2017 |
64256 | 14/02/2017 |
64789 | 01/02/2017 |
64987 | 01/02/2017 |
64541 | 20/02/2017 |
64930 | 20/02/2017 |
64371 | 02/02/2017 |
64236 | 20/02/2017 |
64123 | 15/02/2017 |
64542 | 20/02/2017 |
And I have this query called "Pedidos" where I register requests.
CodigoPedido | Fecha |
10245698 | 01/01/2017 |
10241239 | 05/01/2017 |
10243968 | 05/01/2017 |
10246489 | 10/01/2017 |
10245639 | 12/01/2017 |
10244124 | 15/01/2017 |
10249876 | 20/01/2017 |
10245569 | 25/01/2017 |
10243579 | 25/01/2017 |
10249974 | 05/01/2017 |
10243258 | 06/01/2017 |
10244579 | 07/01/2017 |
10246352 | 08/01/2017 |
10247893 | 03/02/2017 |
10249624 | 02/02/2017 |
10243367 | 02/02/2017 |
10243589 | 05/02/2017 |
10243369 | 05/02/2017 |
10247788 | 20/02/2017 |
10243987 | 10/02/2017 |
10245564 | 03/02/2017 |
I'd like to summarize -in just one table- total calls and total requests by month.
Período | Llamados | Pedidos |
ene-17 | 6 | 13 |
feb-17 | 9 | 9 |
I've been trying with some examples using SUMMARIZE commands, but I was imposible.
Hope you can help me.
Regards!
Iván
Solved! Go to Solution.
Hi Ivan:
My way to solve this is:
1. Create a calendar Table
Modeling-New Table
CalendarTable=CalendarAuto()
2. Add a Calculated Column to the Month-Year Column
Mes = FORMAT(CalendarTable[Date],"MMM-YY")
3. Related CalendarTable with Pedidos & Llamados
4. Create the Summarized Table
Modeling-New Table
Consolidado = SUMMARIZECOLUMNS ( CalendarTable[Mes], "Pedidos", COUNT ( Pedidos[CodigoPedido] ), "Llamados", COUNT ( Llamados[CodigoLlamado] ) )
Hi Ivan:
My way to solve this is:
1. Create a calendar Table
Modeling-New Table
CalendarTable=CalendarAuto()
2. Add a Calculated Column to the Month-Year Column
Mes = FORMAT(CalendarTable[Date],"MMM-YY")
3. Related CalendarTable with Pedidos & Llamados
4. Create the Summarized Table
Modeling-New Table
Consolidado = SUMMARIZECOLUMNS ( CalendarTable[Mes], "Pedidos", COUNT ( Pedidos[CodigoPedido] ), "Llamados", COUNT ( Llamados[CodigoLlamado] ) )
It worked so smoothly that all I want to say you is THANK YOU!
I didn't realize than an intermediate table could help me... and SUMMARIZE COLUMNS of course.
Again, thanks a lot.
Iván
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |