Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
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
User | Count |
---|---|
51 | |
36 | |
20 | |
15 | |
13 |
User | Count |
---|---|
94 | |
72 | |
29 | |
22 | |
14 |