cancel
Showing results for 
Search instead for 
Did you mean: 
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 IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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 IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors