Forum Discussion

jmarlatt's avatar
jmarlatt
New Member
9 years ago
Solved

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. ...
  • Phil_Seamark's avatar
    Phil_Seamark
    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)      



    )