Forum Discussion
Add conditional column based on columns in two different tables without relationship
Hi, I am new to Power BI and I am struggling with a task I am unable to figure out how to implement. I have two tables, both of which has an ID-field with the same type of ID. The first table has ...
Jihwan_Kim
Super User
Super User
Product CC =
VAR _currentID = Table1[ID]
VAR _resulttable =
FILTER (
Table2,
Table2[ID] = _currentID
&& Table2[Start date] <= Table1[Date (DD.MM.YYYY)]
&& Table2[End date] >= Table1[Date (DD.MM.YYYY)]
)
RETURN
DISTINCT ( SELECTCOLUMNS ( _resulttable, "@product", Table2[Product] ) )
Thank you so much!