Create a new column in a table based on data in another column

[bleysamber]

hey all

i have a table that contains information in the following format: 

ID	CUSTOMFIELD	STRINGVALUE
569590	18111	text 1
569590	18301	text 2
569590	18419	34783
569590	18420	34786
569590	18421	34789
569590	18422	34790
569590	18423	34795
569590	18424	34798
569590	18433	34823
569590	18434	34828
569590	18435	34925
569591	18111	text1
569592	18111	text2
569594	18111	text3
569594	18419	34783
569594	18420	34786
569594	18421	34789
569594	18422	34790
569594	18423	34795
569594	18424	34798
569594	18426	34802
569594	18427	34929
569594	18428	34810
569594	18429	34945
569594	18430	34815
569594	18431	34818
569594	18432	34820
569594	18433	34823
569594	18434	34826
569594	18435	34831

lets call this table CUSTOM i have a second table called MAIN that links to CUSTOM in a one to many relationship based on the ID field. As you can see there can be a large number of rows in CUSTOM that have the same ID

i know it might be hard to visualize but for multiple reasons i need to create a new column in MAIN that contains the value from CUSTOM[STRINGVALUE] when CUSTOM[CUSTOMFIELD]=18111 AND MAIN[ID] = CUSTOM[ID]

i have been trying various things using posts ont his forum but i have not been able to make this work, any help would be appreciated

[v-jiascu-msft]

Hi @bleysamber,

Could you please mark the proper answer if it's convenient for you? That will be a help to the others.

Best Regards!
Dale

[OpenDataLab · Accepted solution]

Take a look at using the dax function LOOKUPVALUE it works in very much the same way as vlookup in Excel and should help you solve your problem.

https://msdn.microsoft.com/en-us/library/gg492170.aspx

Let me know how you get on.