topic Top N caller by date in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-N-caller-by-date/m-p/2146612#M49410 <P>I need some help for (what it looks like) a simple waiting time calculation.</P><P>Example table:</P><P><img /></P><P>&nbsp;</P><P>So I want to calculate the caller with the longest waiting time.</P><P>Result should be like:</P><P><img /></P><P>Any help would be appreciated.</P><P>&nbsp;</P> Wed, 20 Oct 2021 20:53:51 GMT Anonymous 2021-10-20T20:53:51Z Top N caller by date https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-N-caller-by-date/m-p/2146612#M49410 <P>I need some help for (what it looks like) a simple waiting time calculation.</P><P>Example table:</P><P><img /></P><P>&nbsp;</P><P>So I want to calculate the caller with the longest waiting time.</P><P>Result should be like:</P><P><img /></P><P>Any help would be appreciated.</P><P>&nbsp;</P> Wed, 20 Oct 2021 20:53:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-N-caller-by-date/m-p/2146612#M49410 Anonymous 2021-10-20T20:53:51Z Re: Top N caller by date https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-N-caller-by-date/m-p/2146647#M49413 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P><P>&nbsp;</P><P>Can you share a sample of your data in the table format to be able to copy and past that (Not Image <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> )</P><P>&nbsp;</P><P><STRONG>Appreciate your Kudos!!</STRONG></P><P>&nbsp;</P> Wed, 20 Oct 2021 21:24:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-N-caller-by-date/m-p/2146647#M49413 VahidDM 2021-10-20T21:24:30Z Re: Top N caller by date https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-N-caller-by-date/m-p/2146958#M49427 <P>You should use an unique id for each start/end pair</P> <P><img /></P> Thu, 21 Oct 2021 02:19:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-N-caller-by-date/m-p/2146958#M49427 CNENFRNL 2021-10-21T02:19:49Z Re: Top N caller by date https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-N-caller-by-date/m-p/2192263#M51273 <TABLE><TBODY><TR><TD>Time</TD><TD>Duration</TD><TD>Caller</TD><TD>Call ID</TD><TD>Index</TD></TR><TR><TD>13:41</TD><TD>00:00</TD><TD>1234</TD><TD>e518bca3a1ad</TD><TD>1</TD></TR><TR><TD>13:42</TD><TD>00:00</TD><TD>1234</TD><TD>e518bca3a1ad</TD><TD>2</TD></TR><TR><TD>13:43</TD><TD>00:00</TD><TD>1234</TD><TD>e518bca3a1ad</TD><TD>3</TD></TR><TR><TD>13:43</TD><TD>00:00</TD><TD>5678</TD><TD>e8c03f3cfe2a</TD><TD>1</TD></TR><TR><TD>13:44</TD><TD>00:00</TD><TD>1234</TD><TD>e518bca3a1ad</TD><TD>4</TD></TR><TR><TD>13:44</TD><TD>00:00</TD><TD>5678</TD><TD>e8c03f3cfe2a</TD><TD>2</TD></TR><TR><TD>13:45</TD><TD>00:00</TD><TD>1234</TD><TD>e518bca3a1ad</TD><TD>5</TD></TR><TR><TD>13:45</TD><TD>01:46</TD><TD>5678</TD><TD>e8c03f3cfe2a</TD><TD>3</TD></TR><TR><TD>13:45</TD><TD>00:00</TD><TD>1234</TD><TD>e518bca3a1ad</TD><TD>6</TD></TR><TR><TD>13:46</TD><TD>00:00</TD><TD>1234</TD><TD>e518bca3a1ad</TD><TD>7</TD></TR><TR><TD>13:47</TD><TD>00:00</TD><TD>1234</TD><TD>e518bca3a1ad</TD><TD>8</TD></TR><TR><TD>13:48</TD><TD>00:00</TD><TD>1234</TD><TD>e518bca3a1ad</TD><TD>9</TD></TR><TR><TD>14:03</TD><TD>00:00</TD><TD>9876</TD><TD>9be71da773a2</TD><TD>1</TD></TR><TR><TD>14:04</TD><TD>00:00</TD><TD>9876</TD><TD>9be71da773a2</TD><TD>2</TD></TR><TR><TD>14:04</TD><TD>00:00</TD><TD>1234</TD><TD>3cefb8f84ddf</TD><TD>1</TD></TR><TR><TD>14:05</TD><TD>00:00</TD><TD>9876</TD><TD>9be71da773a2</TD><TD>3</TD></TR><TR><TD>14:05</TD><TD>00:00</TD><TD>1234</TD><TD>3cefb8f84ddf</TD><TD>2</TD></TR><TR><TD>14:06</TD><TD>03:32</TD><TD>9876</TD><TD>9be71da773a2</TD><TD>4</TD></TR><TR><TD>14:06</TD><TD>00:00</TD><TD>1234</TD><TD>3cefb8f84ddf</TD><TD>3</TD></TR><TR><TD>14:07</TD><TD>00:00</TD><TD>1234</TD><TD>3cefb8f84ddf</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Result should be:</P><TABLE><TBODY><TR><TD>Caller</TD><TD>Total duration without being answered</TD></TR><TR><TD>1234</TD><TD>00:10</TD></TR></TBODY></TABLE> Tue, 16 Nov 2021 10:59:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-N-caller-by-date/m-p/2192263#M51273 Anonymous 2021-11-16T10:59:24Z