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
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
Resolver 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