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.
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
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |