Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculating a time difference based on two times spread over two tables

Hi there,   I'm fairly new to PowerBI, so it might be a dumb question. I have the following tables:   Sentinel-incidents contain security incidents from our system. A single incident might ...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Anonymous , Try a measure like

     

    AverageX('Sentinel-incidents', datediff(min('Sentinel-task'[CreatedTimeutc]), max('Sentinel-comment'[CreatedTimeutc]), MINUTE))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Anonymous , Try a measure like

 

AverageX('Sentinel-incidents', datediff(min('Sentinel-task'[CreatedTimeutc]), max('Sentinel-comment'[CreatedTimeutc]), MINUTE))

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi amitchandak,
    Awesome! That's exactly what I'm looking for, thanks for the help!