Calculate a value based on Look up on a particular table to match with current column

[sivarajan21]

Hi,

I have two tables as below:

Point id table:

DBName-Point_Id

INSE-2

INSE-3

INSE-6

INSE-7

INSE-1421

INSE-1422

INSE-1438

INSE-1439

Contracts table:

DBName-PointId	DBName-ContractsId
INSE-1421	INSE-28
INSE-1422	INSE-29
INSE-1438	INSE-24
INSE-1439	INSE-25

Contracts data table:

DBName-ContractsId	cost rate
INSE-28	3.2
INSE-29	4.5
INSE-24	6.2
INSE-25	7

Now we want to create a measure to calculae the cost rate which is in contracts data table for each point in point id table.

I am confused how to lookup this DBName-ContractsId for their corresponding DBName-PointId.

The relationship b/w these tables :

Can you please help me resolve this?

Let me know if you need further info.

@Ahmedx @lbendlin @Greg_Deckler @amitchandak @Ashish_Mathur @grantsamborn 

[Ahmedx · Accepted solution]

Is this what you are looking for?

[sivarajan21]

Hi @Ahmedx 

Thanks for this amazing solution! yes perfectly what I was looking for!

You made my day and am still learning from you😊

I will accept this as my solution and close this query.

Can you suggest me any books or blogs to better learn power bi ?

Also, please feel free to share any learning style that will enable me to understand power bi like you!

[Ahmedx]

The Definitive Guide to DAX

Analyzing Data with Power BI and Power Pivot for Excel

[sivarajan21]

Hi @Ahmedx 

Many thanks