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 learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.