Forum Discussion
170323003
Helper I
Helper IAverage Booking Date
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 ---> ...
amitchandak
Super User
Super User170323003 , 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-Difference-Across/ba-p/934397#M451