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)
)
jmarlatt
9 years agoNew Member
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...
Phil_Seamark
9 years agoMicrosoft Employee
What does the error say when you hover over it?