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
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.