topic Re: Find the minimum value within grouped data in Desktop
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133000#M56801
<P>Thank you! Here is some data. Sanitized but still relevent.</P><P> </P><TABLE><TBODY><TR><TD>IncidentNo</TD><TD>ActionID</TD><TD>ActionDateTime</TD><TD>ActionDescription</TD></TR><TR><TD>INC201702210542</TD><TD>4379983</TD><TD>2/22/17 6:57 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220114</TD><TD>4380010</TD><TD>2/22/17 7:03 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220114</TD><TD>4380011</TD><TD>2/22/17 7:03 AM</TD><TD>Incident assigned to department: ---</TD></TR><TR><TD>INC201702220114</TD><TD>4380012</TD><TD>2/22/17 7:03 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210573</TD><TD>4380187</TD><TD>2/22/17 7:47 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210647</TD><TD>4380210</TD><TD>2/22/17 7:53 AM</TD><TD>Incident status set to Unpaused</TD></TR><TR><TD>INC201702160221</TD><TD>4380218</TD><TD>2/22/17 7:55 AM</TD><TD>Incident status set to Unpaused</TD></TR><TR><TD>INC201702210647</TD><TD>4380220</TD><TD>2/22/17 7:55 AM</TD><TD>Incident unassigned</TD></TR><TR><TD>INC201702160221</TD><TD>4380224</TD><TD>2/22/17 7:57 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702210647</TD><TD>4380228</TD><TD>2/22/17 7:57 AM</TD><TD>Incident unassigned</TD></TR><TR><TD>INC201702210647</TD><TD>4380283</TD><TD>2/22/17 8:07 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210313</TD><TD>4380365</TD><TD>2/22/17 8:16 AM</TD><TD>Incident status set to Unpaused</TD></TR><TR><TD>INC201702210313</TD><TD>4380381</TD><TD>2/22/17 8:20 AM</TD><TD>Incident unassigned</TD></TR><TR><TD>INC201702220142</TD><TD>4380385</TD><TD>2/22/17 8:21 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220142</TD><TD>4380386</TD><TD>2/22/17 8:21 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702220142</TD><TD>4380387</TD><TD>2/22/17 8:21 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210313</TD><TD>4380401</TD><TD>2/22/17 8:22 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702220142</TD><TD>4380403</TD><TD>2/22/17 8:22 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 3</TD></TR><TR><TD>INC201702220142</TD><TD>4380404</TD><TD>2/22/17 8:22 AM</TD><TD>Incident assigned to department: ---</TD></TR><TR><TD>INC201702220142</TD><TD>4380405</TD><TD>2/22/17 8:22 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702220147</TD><TD>4380418</TD><TD>2/22/17 8:25 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220147</TD><TD>4380419</TD><TD>2/22/17 8:25 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702220149</TD><TD>4380424</TD><TD>2/22/17 8:26 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220149</TD><TD>4380425</TD><TD>2/22/17 8:26 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702220149</TD><TD>4380426</TD><TD>2/22/17 8:26 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702220149</TD><TD>4380437</TD><TD>2/22/17 8:27 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220149</TD><TD>4380438</TD><TD>2/22/17 8:27 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 1</TD></TR><TR><TD>INC201702220147</TD><TD>4380471</TD><TD>2/22/17 8:30 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 1</TD></TR><TR><TD>INC201702220147</TD><TD>4380472</TD><TD>2/22/17 8:30 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702220147</TD><TD>4380518</TD><TD>2/22/17 8:36 AM</TD><TD>Incident ESCALATED from TIER 1 to TIER 3</TD></TR><TR><TD>INC201702220147</TD><TD>4380519</TD><TD>2/22/17 8:36 AM</TD><TD>Incident assigned to department: ---</TD></TR><TR><TD>INC201702220147</TD><TD>4380520</TD><TD>2/22/17 8:36 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702220158</TD><TD>4380533</TD><TD>2/22/17 8:37 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220158</TD><TD>4380534</TD><TD>2/22/17 8:37 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702210674</TD><TD>4380585</TD><TD>2/22/17 8:45 AM</TD><TD>Incident set to unresolved</TD></TR><TR><TD>INC201702210647</TD><TD>4380598</TD><TD>2/22/17 8:46 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220158</TD><TD>4380616</TD><TD>2/22/17 8:48 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 1</TD></TR><TR><TD>INC201702220158</TD><TD>4380617</TD><TD>2/22/17 8:48 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210313</TD><TD>4380643</TD><TD>2/22/17 8:51 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702170511</TD><TD>4380666</TD><TD>2/22/17 8:53 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220173</TD><TD>4380738</TD><TD>2/22/17 9:04 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220173</TD><TD>4380739</TD><TD>2/22/17 9:04 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702220173</TD><TD>4380773</TD><TD>2/22/17 9:09 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 1</TD></TR><TR><TD>INC201702220173</TD><TD>4380774</TD><TD>2/22/17 9:09 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210313</TD><TD>4380803</TD><TD>2/22/17 9:12 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220178</TD><TD>4380807</TD><TD>2/22/17 9:12 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220178</TD><TD>4380808</TD><TD>2/22/17 9:12 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702220178</TD><TD>4380813</TD><TD>2/22/17 9:13 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 1</TD></TR><TR><TD>INC201702220178</TD><TD>4380814</TD><TD>2/22/17 9:13 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210247</TD><TD>4380819</TD><TD>2/22/17 9:14 AM</TD><TD>Incident status set to Unpaused</TD></TR><TR><TD>INC201702210638</TD><TD>4380827</TD><TD>2/22/17 9:15 AM</TD><TD>Incident status set to Unpaused</TD></TR><TR><TD>INC201702210247</TD><TD>4380838</TD><TD>2/22/17 9:17 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220178</TD><TD>4380919</TD><TD>2/22/17 9:25 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220191</TD><TD>4380932</TD><TD>2/22/17 9:26 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220191</TD><TD>4380933</TD><TD>2/22/17 9:26 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR></TBODY></TABLE>Fri, 24 Feb 2017 19:30:02 GMTjmarlatt2017-02-24T19:30:02ZFind the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/132970#M56790
<P>Hello,</P><P> </P><P>I need to replication a query that is done in access on a table within Powerbi. Im new to powerbi as well. </P><P> </P><P>So a little background first, i am reporting on a Help Desk ticking system. This system is home grown and only have access to certian sub-sets of records. </P><P> </P><P>1 of these tables is "StaffActions" basically a record of every single action that occurs on a help desk ticket, for all tickets that were actioned on. </P><P> </P><P>For every IncidentNo, there are multiple unique ActionID. These ActionID has an associated Action Description, ActionDateTime. </P><P> </P><P>I need to filter only actions that the ActionDescription has "Incident assigned to:*" (Notice the wild card) </P><P> </P><P>Now most incidents eventually have multiple "Incidents assigned to:*" records. Since they get escalated and bounced around to different engineers. </P><P> </P><P>I then need to find the ActionDateTime of the earliest record for each IncidentNo in the table. </P><P> </P><P>I can do it in Access using the below query:</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2017-02-24_13-17-45.png" style="width: 600px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/30793iCA6C1C0677C0E055/image-size/large?v=1.0&px=999" title="2017-02-24_13-17-45.png" alt="2017-02-24_13-17-45.png" /></span></P><P> </P><P>I spent several hours trying to figure out how to do this in a calculated column, or calcutlated table and no luck. </P><P> </P><P>End result is I will compare the "FristActionDateTime" for each ticket to the tickets OpenDateTime to find out how long each time waited in the queue before its first assignment. </P><P> </P><P>Any ideas, is this even possible with PowerBi? </P><P> </P>Fri, 24 Feb 2017 18:35:29 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/132970#M56790jmarlatt2017-02-24T18:35:29ZRe: Find the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/132992#M56796
<P>Hi <LI-USER uid="22356"></LI-USER>,</P><P> </P><P>Any chance you can provide a small sampe set of data? I reckon we can come up with something pretty quickly for you if you do.</P>Fri, 24 Feb 2017 19:07:10 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/132992#M56796Phil_Seamark2017-02-24T19:07:10ZRe: Find the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133000#M56801
<P>Thank you! Here is some data. Sanitized but still relevent.</P><P> </P><TABLE><TBODY><TR><TD>IncidentNo</TD><TD>ActionID</TD><TD>ActionDateTime</TD><TD>ActionDescription</TD></TR><TR><TD>INC201702210542</TD><TD>4379983</TD><TD>2/22/17 6:57 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220114</TD><TD>4380010</TD><TD>2/22/17 7:03 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220114</TD><TD>4380011</TD><TD>2/22/17 7:03 AM</TD><TD>Incident assigned to department: ---</TD></TR><TR><TD>INC201702220114</TD><TD>4380012</TD><TD>2/22/17 7:03 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210573</TD><TD>4380187</TD><TD>2/22/17 7:47 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210647</TD><TD>4380210</TD><TD>2/22/17 7:53 AM</TD><TD>Incident status set to Unpaused</TD></TR><TR><TD>INC201702160221</TD><TD>4380218</TD><TD>2/22/17 7:55 AM</TD><TD>Incident status set to Unpaused</TD></TR><TR><TD>INC201702210647</TD><TD>4380220</TD><TD>2/22/17 7:55 AM</TD><TD>Incident unassigned</TD></TR><TR><TD>INC201702160221</TD><TD>4380224</TD><TD>2/22/17 7:57 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702210647</TD><TD>4380228</TD><TD>2/22/17 7:57 AM</TD><TD>Incident unassigned</TD></TR><TR><TD>INC201702210647</TD><TD>4380283</TD><TD>2/22/17 8:07 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210313</TD><TD>4380365</TD><TD>2/22/17 8:16 AM</TD><TD>Incident status set to Unpaused</TD></TR><TR><TD>INC201702210313</TD><TD>4380381</TD><TD>2/22/17 8:20 AM</TD><TD>Incident unassigned</TD></TR><TR><TD>INC201702220142</TD><TD>4380385</TD><TD>2/22/17 8:21 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220142</TD><TD>4380386</TD><TD>2/22/17 8:21 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702220142</TD><TD>4380387</TD><TD>2/22/17 8:21 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210313</TD><TD>4380401</TD><TD>2/22/17 8:22 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702220142</TD><TD>4380403</TD><TD>2/22/17 8:22 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 3</TD></TR><TR><TD>INC201702220142</TD><TD>4380404</TD><TD>2/22/17 8:22 AM</TD><TD>Incident assigned to department: ---</TD></TR><TR><TD>INC201702220142</TD><TD>4380405</TD><TD>2/22/17 8:22 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702220147</TD><TD>4380418</TD><TD>2/22/17 8:25 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220147</TD><TD>4380419</TD><TD>2/22/17 8:25 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702220149</TD><TD>4380424</TD><TD>2/22/17 8:26 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220149</TD><TD>4380425</TD><TD>2/22/17 8:26 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702220149</TD><TD>4380426</TD><TD>2/22/17 8:26 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702220149</TD><TD>4380437</TD><TD>2/22/17 8:27 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220149</TD><TD>4380438</TD><TD>2/22/17 8:27 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 1</TD></TR><TR><TD>INC201702220147</TD><TD>4380471</TD><TD>2/22/17 8:30 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 1</TD></TR><TR><TD>INC201702220147</TD><TD>4380472</TD><TD>2/22/17 8:30 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702220147</TD><TD>4380518</TD><TD>2/22/17 8:36 AM</TD><TD>Incident ESCALATED from TIER 1 to TIER 3</TD></TR><TR><TD>INC201702220147</TD><TD>4380519</TD><TD>2/22/17 8:36 AM</TD><TD>Incident assigned to department: ---</TD></TR><TR><TD>INC201702220147</TD><TD>4380520</TD><TD>2/22/17 8:36 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702220158</TD><TD>4380533</TD><TD>2/22/17 8:37 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220158</TD><TD>4380534</TD><TD>2/22/17 8:37 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702210674</TD><TD>4380585</TD><TD>2/22/17 8:45 AM</TD><TD>Incident set to unresolved</TD></TR><TR><TD>INC201702210647</TD><TD>4380598</TD><TD>2/22/17 8:46 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220158</TD><TD>4380616</TD><TD>2/22/17 8:48 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 1</TD></TR><TR><TD>INC201702220158</TD><TD>4380617</TD><TD>2/22/17 8:48 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210313</TD><TD>4380643</TD><TD>2/22/17 8:51 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702170511</TD><TD>4380666</TD><TD>2/22/17 8:53 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220173</TD><TD>4380738</TD><TD>2/22/17 9:04 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220173</TD><TD>4380739</TD><TD>2/22/17 9:04 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702220173</TD><TD>4380773</TD><TD>2/22/17 9:09 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 1</TD></TR><TR><TD>INC201702220173</TD><TD>4380774</TD><TD>2/22/17 9:09 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210313</TD><TD>4380803</TD><TD>2/22/17 9:12 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220178</TD><TD>4380807</TD><TD>2/22/17 9:12 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220178</TD><TD>4380808</TD><TD>2/22/17 9:12 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR><TR><TD>INC201702220178</TD><TD>4380813</TD><TD>2/22/17 9:13 AM</TD><TD>Incident ESCALATED from TRIAGE to TIER 1</TD></TR><TR><TD>INC201702220178</TD><TD>4380814</TD><TD>2/22/17 9:13 AM</TD><TD>Incident assigned to: Doe, John</TD></TR><TR><TD>INC201702210247</TD><TD>4380819</TD><TD>2/22/17 9:14 AM</TD><TD>Incident status set to Unpaused</TD></TR><TR><TD>INC201702210638</TD><TD>4380827</TD><TD>2/22/17 9:15 AM</TD><TD>Incident status set to Unpaused</TD></TR><TR><TD>INC201702210247</TD><TD>4380838</TD><TD>2/22/17 9:17 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220178</TD><TD>4380919</TD><TD>2/22/17 9:25 AM</TD><TD>Incident set to resolved</TD></TR><TR><TD>INC201702220191</TD><TD>4380932</TD><TD>2/22/17 9:26 AM</TD><TD>Incident status set to open</TD></TR><TR><TD>INC201702220191</TD><TD>4380933</TD><TD>2/22/17 9:26 AM</TD><TD>Incident assigned to department: Help Desk</TD></TR></TBODY></TABLE>Fri, 24 Feb 2017 19:30:02 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133000#M56801jmarlatt2017-02-24T19:30:02ZRe: Find the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133007#M56806
<P><LI-USER uid="22356"></LI-USER>The steps and image have been updated!</P><P>In the Query Editor</P><P>1) Add a Conditional Column and then filter the results as shown below</P><P>2) then Group By Incident Number by Min ActionDateTime</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="QE - Keep Only Assigned To.gif" style="width: 600px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/30810i2B4BFC55AE3842B9/image-size/large?v=1.0&px=999" title="QE - Keep Only Assigned To.gif" alt="QE - Keep Only Assigned To.gif" /></span></P><P> </P><P>Hope this helps! <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://community.powerbi.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P>Fri, 24 Feb 2017 20:49:17 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133007#M56806Sean2017-02-24T20:49:17ZRe: Find the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133009#M56807
<P>I don't think I have this 100% right but we might be close.</P><P> </P><P>This returns a table of incidents showing the duration between the first datetime of the incident and the duration of each step in minutes for each step for each subsequent step.</P><P> </P><P> </P><PRE>Table =
VAR T1 = SUMMARIZE(
FILTER(
'Incidents',
LEFT([ActionDescription],20)="Incident assigned to"
),
Incidents[IncidentNo],
"First Assigned",MIN('Incidents'[ActionDateTime])
)
RETURN ADDCOLUMNS(
NATURALINNERJOIN('Incidents',T1),
"Duration",IFERROR(DATEDIFF([First Assigned],'Incidents'[ActionDateTime],MINUTE) ,0) <BR /><BR /><BR /><BR /> )</PRE>Fri, 24 Feb 2017 19:50:18 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133009#M56807Phil_Seamark2017-02-24T19:50:18ZRe: Find the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133010#M56808
<P>Im also using the StaffAction table for other infromation. I dont see a way to use a seperate query thats not using data from the source. </P>Fri, 24 Feb 2017 19:51:31 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133010#M56808jmarlatt2017-02-24T19:51:31ZRe: Find the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133016#M56810
<P>OK, its getting there.... Need to understand all this so breaking it down. I did the following to see what I would get in the table and error check.. but getting a column with #Error...</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2017-02-24_15-00-15.png" style="width: 584px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/30807i150A16B1A55E4B25/image-size/large?v=1.0&px=999" title="2017-02-24_15-00-15.png" alt="2017-02-24_15-00-15.png" /></span></P>Fri, 24 Feb 2017 20:00:50 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133016#M56810jmarlatt2017-02-24T20:00:50ZRe: Find the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133020#M56814
<P>Ha, it was a calculated column that got left in there that I was playing with earlier! the code does not generate any error. Once I validate results, adding the rest of the code to get the time difference... thank you!!!!</P>Fri, 24 Feb 2017 20:11:50 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133020#M56814jmarlatt2017-02-24T20:11:50ZRe: Find the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133021#M56815
<P>What does the error say when you hover over it?</P><P> </P>Fri, 24 Feb 2017 20:12:12 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133021#M56815Phil_Seamark2017-02-24T20:12:12ZRe: Find the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133022#M56816
<P>Nice work. </P><P> </P><P>I can add a Ranking column to the table too if you want and index of the incident actions per incident</P>Fri, 24 Feb 2017 20:13:16 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133022#M56816Phil_Seamark2017-02-24T20:13:16ZRe: Find the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133024#M56818
<P>That sounds intresting! It would be great to see that! Also In additon to the text "Incident assigned to:" the actiondescription could also read "Incident acknowledged" which ever would come first is the time stamp i need to use. </P>Fri, 24 Feb 2017 20:17:16 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133024#M56818jmarlatt2017-02-24T20:17:16ZRe: Find the minimum value within grouped data
https://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133487#M57032
<P>Hi <LI-USER uid="22356"></LI-USER>,<BR /><BR />Have you resolved your issue? If you have resolved it, please mark the right reply as answer, so other people will find solution clearly. If you have not resolve the problem, please feel free to ask.<BR /><BR />Best Regards,<BR />Angelia</P>Mon, 27 Feb 2017 08:47:42 GMThttps://community.powerbi.com/t5/Desktop/Find-the-minimum-value-within-grouped-data/m-p/133487#M57032v-huizhn-msft2017-02-27T08:47:42Z