Showing results for 
Search instead for 
Did you mean: 
New Member

Assign a property to a point from a property interval located in a different table


I would please like to know how I could assign a property "X" to a table of punctual data (single depth points) by looking at a second table that contains this property as intervals (columns: "top depth", "bottom depth", "property X").


For example I have a sample "A" at a depth of 8600m (single point) in my first table (called "CCA" table) and I would like to assign to this point the value "PFMW" of the property "LITHOFACIES" from the second table (called "Facies", see table below) because at depth 8600m the corresponding "LITHOFACIES" value is "PFMW" in between 8500 and 8770m


Table 2 ("Facies"):



How would be the best way to do this with powerBI, a formula? a link between tables?


Hope I am clear.


Many thanks for the great help.

Community Support
Community Support


You could create a relationship between TOP depth columns in the 2 tables, then create a calculate column to get property X value into table2. 


property X = Related(Table 1[property X])



Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Thank you very much for the help.


My problem is that "top depth" is only available in table 2 not in table 1 since depths are intervals only in the table 2, in the table 1 depths are punctual so it is just "depth" and "depth" doesn't correspond in most cases to a "top" or "bottom depth" of an interval but is most of the time located in between the top and bottom depths of an interval not exactly at the same depth.


Thanks a lot again.

Super User
Super User

@Lepaleo sorry it is not clear what you are looking for. Read this post to get your answer quickly.

Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 episode 5 with aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt will talk about the importance of Data Modeling.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!