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. ...
Need Help
  • 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)      



     )
jmarlatt's avatar
jmarlatt
New Member
9 years ago

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.  

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi jmarlatt,

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.

Best Regards,
Angelia