Forum Discussion

StephenM's avatar
StephenM
Regular Visitor
6 years ago

Time since an event

Hi, I'm trying to figure out how to calculate the number of minutes/seconds/whatever since an event occurred in my data.  I have a table of time series data (on sample every five minutes), every now...
Need Help
bpsearle's avatar
bpsearle
Icon for Resolver II rankResolver II
6 years ago

Hi Steve

Can you post a screen shot of the excel example and of your data table please?

Thanks, Brian

StephenM's avatar
StephenM
Regular Visitor
6 years ago

Hi Brian,

Below is the screen shot of my excel example (I have hidden about 600 lines between the 5 and the 2955 to show the first event):

 

The data table in power bi is pretty much the same.  There are a couple of extra columns (I've added an index and some un-related calculated columns).  The data table has just over 100,000 rows

 

Hopefully that helps but let me know if you need any more info.

 

Thanks

Steve

  • bpsearle's avatar
    bpsearle
    Icon for Resolver II rankResolver II
    6 years ago

    Hi Steve, sorry for the delay, I've been crazy busy with a project. Do you still need help with this?

    Thanks, Brian

    • StephenM's avatar
      StephenM
      Regular Visitor
      6 years ago

      Hi Brian, No worries. The urgency for a solution has dropped off a bit but I will still need to solve the problem at some point.  So keen to hear any suggestions you may have.

       

      Thanks

      Steve