Forum Discussion
Look up data and append to same row within table
Hello Experts, I have an interesting use case where I have data contained in a table, but the data does not contain a certain level of information that I need for visualization purposes. I need t...
If you want the column in DAX, you can do as below: Say, your table is
Parent_Child_LookupFriend Name = LOOKUPVALUE(Parent_Child_Lookup[Name], Parent_Child_Lookup[ID], Parent_Child_Lookup[Friend ID], BLANK())
That worked perfectly! Thank you very much! I knew it was something simple using the LOOKUPVALUE function, I just couldn't figure it out. Much appreciated.
Glad to hear that it worked ! Thanks