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.
So:
What i want:
Average allocation time by park and type of equipment
I want to know, in average, how many time do bookings take to be allocated.
The relations are
Bookings ---> Equipment ---> Reserve
I've tried something that is wrong i guess, because there's no direct relation between bookings and reserves:
(measure)
@170323003 - You can use LOOKUPVALUE to lookup values between unrelated tables. Also, if that is truly a measure then I would think you would need a min/max aggregation or something similar.
Overall, not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi @170323003 ,
See if this helps.
Create a Column for Time Difference and then calculate the Average.
https://community.powerbi.com/t5/Desktop/Help-with-average-of-time-calculations/td-p/152270
Regards,
Harsh Nathani
hi @harshnathani !
ty for ur response.
i understood the posts u sent to me, but my problem is that i dont have starttime and end time in the same table, and they dont tven have relation (only with another table in the middle of them).
what do u suggest in this scenario?
@170323003 , Seem like they are in different tables. make sure common dimesion like booking id and use values(bookingDIm[booking_id]) Or summarize in case you have more than one common key
Refer this blog : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Differ...
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |