Forum Discussion
jmarlatt
9 years agoNew Member
Find the minimum value within grouped data
Hello, I need to replication a query that is done in access on a table within Powerbi. Im new to powerbi as well. So a little background first, i am reporting on a Help Desk ticking system. ...
- 9 years ago
I don't think I have this 100% right but we might be close.
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.
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)
)
Sean
9 years agoCommunity Champion
jmarlattThe steps and image have been updated!
In the Query Editor
1) Add a Conditional Column and then filter the results as shown below
2) then Group By Incident Number by Min ActionDateTime
Hope this helps! :smileyhappy:
jmarlatt
9 years agoNew Member
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.