Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I'm new to "power bi" I'm working on a project with direct query
I need to get the AVERAGE, grouped by hours.
Solved! Go to Solution.
Do you have a Arrival Time column in your table? If yes, please try with following measure.
AVERAGE = FORMAT ( CALCULATE ( AVERAGE ( Table1[Arrival Time] ), ALLEXCEPT ( Table1, Table1[TimeHour] ) ), "HH:MM: SS" )
Best Regards,
Herbert
Has your problem got resolved? If yes, you can mark the right answer as solution so that other people who have the same problem can find the right answer quickly.
Best Regards,
Herbert
Hi, if your answer helped me with the above problem.
But I have another very similar problem in that I try to use the same formula but I can not make it work.
I'm working with "direct query" and I need to get the average "work time"
Something very similar to this. AVERAGE_WT = FORMAT (AVERAGE (View_AllRequests [Average Work Time]), "HH: MM: SS")
But I always get error.
Do you have a Arrival Time column in your table? If yes, please try with following measure.
AVERAGE = FORMAT ( CALCULATE ( AVERAGE ( Table1[Arrival Time] ), ALLEXCEPT ( Table1, Table1[TimeHour] ) ), "HH:MM: SS" )
Best Regards,
Herbert
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |