Hello. I did not really get why we use AvgX at 17:52. From my level of understanding AvgX Age is 25 so it should always return the same result in the AgeGroup as the average age does not change. Please help me understand.
Great question! [AvgX Age] is a calculated measure. It's value is not fixed. It will change depend on the evaluation context. You can watch this video to see what evaluation context means ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-G67LUb5kiUA.html You can try to put [AvgX Age] directly in the calculated column you'll see the value change accordingly. Why? The evaluation context for employee 1 would be: Filter Context: Employee = 1 & Row Context: Age calculation => result [AvgX Age] for employee = 20 Then the process repeat: Filter Context: Employee = 2 & Row Context: Age calculation => result [AvgX Age] for employee = 21 till the end of the table.
Good question :) clock in and clock out time is in time format (duration) - to convert to Minute you need to * 1440 - to convert to Hour you need to * 1440 / 60 = 24 hour (I want to get the hour) If you don't want to remember these number, alternatively, you can use Datediff to calculate datetime different.