Need help to create a new Column in Table 1 by comparing another table value

[gopinath25]

Need help to create a new Column in Table 1 by comparing another table value without any relationship. Appreciate your help

Example below : Example here

[gopinath25]

@ValtteriN - You saved my time . Here the output Query
NewColumn4 =
var _c = Table1[Column1] return
CALCULATE(MAX(Table2[Column2]),ALL(Table2),CONTAINSSTRING(_c,Table2[Column1]))

[ValtteriN · Accepted solution]

Hi,

Try somehing like this:

Column =

var _c = ItemExample[Item] return

CALCULATE(MAX('Matrix example'[Material]),ALL('Matrix example'),CONTAINSSTRING('Matrix example'[Item],_c))

Example tables:
Matrix example

Item example

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/