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