Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |