Latest Data from Another Table

[jomyts]

Hi All,

I am new in Power Bi. I have a question.

I have two tables 

Table-1

Table-2

I want the latest Location Name from table-2 in table-1 for that particular Order No.

I have made relationship ProdNo.

can anyone helpme 

[v-yifanw-msft]

Thank you @Ahmedx   for your prompt reply.

Hi @jomyts ,
May I ask if you have tried the suggestions above? If the suggestion helped you, you might consider marking it as a solution. If the problem has not yet been solved, please feel free to ask us a question.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ahmedx]

you need read about of realted

https://dax.guide/related/