Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |