Forum Discussion

richardburling's avatar
4 years ago
Solved

Earliest Time in my data

Morning, 

 

I hope someone can help me.

In the _m_overallstarttime column I want to repeat 07:09 time for each row.

 

07:09 represents the first issue of the day and I need that in every row where there is a reference number, so a variance calculation can be shown. I am only looking at a daily view so have a calendar date slicer in my report which cant be ignored as depending on which date you select the first issue will be at a different time, anywhere between 05:00 - 23:59.  

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  richardburling ,

     

    Here are the steps you can follow:

    1. Create measure.

    Measure =
    MINX(ALL('Table'),[_m_Start_Time])

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  richardburling ,

     

    Here are the steps you can follow:

    1. Create measure.

    Measure =
    MINX(ALL('Table'),[_m_Start_Time])

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly