Forum Discussion
Modify the LookUpValue function when Search_ColumnName1 contains duplicates
Hi maibacherstr,
I think you can add more search columns to the lookupvalue function to prevent the duplicate value and set the 'alternate Result' option with aggregate function to handle the excepted duplicate results.
formula = LOOKUPVALUE ( Table2[Result], Table2[SearchColumn], Table1[Column], Table2[ProjectName], Table1[ProjectName], MAX ( Table2[Result] ) )LOOKUPVALUE function (DAX) - DAX | Microsoft Docs
Regards,
Xiaoxin Sheng
you can try like
in same table
maxx(filter(Table, Table[Search_ColumnName1] = earlier(Table[Search_Value1]) , [Result_ColumnName])
for across table refer
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
amitchandak I'm a fan of your work from many solutions past; thank you for your time/energy & reply.
I'm reading your formula as a new DAX column. Unfortunately I haven't had the opportunity to focus on building this since you posted it. It may happen over the weekend, and if so I just wanted to check to before then to acknowledge and say thanks.
Have a great weekend!
Hi maibacherstr,
I think you can add more search columns to the lookupvalue function to prevent the duplicate value and set the 'alternate Result' option with aggregate function to handle the excepted duplicate results.
formula = LOOKUPVALUE ( Table2[Result], Table2[SearchColumn], Table1[Column], Table2[ProjectName], Table1[ProjectName], MAX ( Table2[Result] ) )LOOKUPVALUE function (DAX) - DAX | Microsoft Docs
Regards,
Xiaoxin Sheng
