Forum Discussion
DAX Join Error When Using Related Tables
We are going to attempt a JOIN between the two tables below in Power BI. The goal of calculation is to be able to check by time zone in the view table as the time zone appropriate for each type t...
김기만 , You can use expression function for that
New column in Table 2
Maxx(filter(Table1, Table1[Type] = Table2[Wtype] && Timevalue(Table2[DateTime]) > =Table1[Start] && Timevalue(Table2[DateTime]) < =Table1[End] ) , [Status])
Thanks for your answer.
I tried applying your answer, but I only get an Error.
Like the first table, even in one type, data exists in different columns for each time zone. Therefore, it is necessary to be able to express it by adding a table for each date of the day, and an action such as Join is needed to increase the column while joining the table and increase the rows that meet the conditions enough to express Table2 in detail by time.