Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ivandawidowski
New Member

Summarize two different and unrelated queries

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.

 

CodigoLlamadoFecha
6356402/01/2017
6354002/01/2017
6359015/01/2017
6325016/01/2017
6397107/01/2017
6378230/01/2017
6425614/02/2017
6478901/02/2017
6498701/02/2017
6454120/02/2017
6493020/02/2017
6437102/02/2017
6423620/02/2017
6412315/02/2017
6454220/02/2017


And I have this query called "Pedidos" where I register requests.

 

CodigoPedidoFecha
1024569801/01/2017
1024123905/01/2017
1024396805/01/2017
1024648910/01/2017
1024563912/01/2017
1024412415/01/2017
1024987620/01/2017
1024556925/01/2017
1024357925/01/2017
1024997405/01/2017
1024325806/01/2017
1024457907/01/2017
1024635208/01/2017
1024789303/02/2017
1024962402/02/2017
1024336702/02/2017
1024358905/02/2017
1024336905/02/2017
1024778820/02/2017
1024398710/02/2017
1024556403/02/2017



I'd like to summarize -in just one table- total calls and total requests by month.

 

PeríodoLlamadosPedidos
ene-17613
feb-1799



I've been trying with some examples using SUMMARIZE commands, but I was imposible.

Hope you can help me.

Regards!

Iván

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@ivandawidowski

 

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

 

Related.png

 

4. Create the Summarized Table

 

Modeling-New Table

 

Consolidado =
SUMMARIZECOLUMNS (
    CalendarTable[Mes],
    "Pedidos", COUNT ( Pedidos[CodigoPedido] ),
    "Llamados", COUNT ( Llamados[CodigoLlamado] )
)



Lima - Peru

View solution in original post

2 REPLIES 2
Vvelarde
Community Champion
Community Champion

@ivandawidowski

 

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

 

Related.png

 

4. Create the Summarized Table

 

Modeling-New Table

 

Consolidado =
SUMMARIZECOLUMNS (
    CalendarTable[Mes],
    "Pedidos", COUNT ( Pedidos[CodigoPedido] ),
    "Llamados", COUNT ( Llamados[CodigoLlamado] )
)



Lima - Peru

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.