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

[Lepaleo]

Hi,

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.

[V-pazhen-msft]

@Lepaleo 

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.

[Lepaleo]

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.

[parry2k]

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

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490