how to measure between not related tables

[YonghunLee]

I have to check whether the data of each items in ‘Item table’ is between the from and To range of ‘context table’

And finally have to get ‘Result table.’

With Excel, I can do it by making “Is the Data In“ table

In power BI,  how can I do it?

I want to do it with DAX measure without making “Is the Data In” table if possible

 

[v-juanli-msft]

Hi @YonghunLee 

Why two columns of "Data" are different?

Best Regards

Maggie

[amitchandak · Accepted solution]

@YonghunLee , if you want to create a new column from table 2  in table1

New Column = maxx(filter(table2,table2[Col1]= table1[col1] && table2[Col2]= table1[col2] ),table2[required_col])

New Column = maxx(filter(table2,table2[Col1]>= table1[col1] && table2[Col1]<= table1[col2] ),table2[required_col])

In case you need a measure to refer this blog. Check-in Current employee, I have removed join from date table and used it

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...