Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
YonghunLee
Helper I
Helper I

how to measure between not related tables

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

 (반출승인)1.png

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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...

View solution in original post

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @YonghunLee 

Why two columns of "Data" are different?

 

Best Regards

Maggie

amitchandak
Super User
Super User

@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...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors