Forum Discussion
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.
- Anonymous4 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
- AnonymousNot 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