Hi!I'm new to the forum, and I'd like to get any help regarding this issue. I have two datasets connected by time. One of them is a time slot with a status for each of them:
The second table is a timestamp typical table for time-based data:
How I can connect each row of the second table with the appropriate data from the 1st table?
Any help would be appreciated. Thanks!
Go to Solution.
@gmiro , You can get data from first table into second table like
maxx(filter(first, second[Date]>= first[Initial time] && second[Date]<= first[End time]), first[Duration])
also refer the way to get data from one table to another - https://www.youtube.com/watch?v=czNHt7UXIe8
View solution in original post
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.