Forum Discussion

DanielPasalic's avatar
DanielPasalic
Icon for Helper II rankHelper II
6 years ago

Fill a missing data in column based on a value in another column

Hello  I have a table with ranking data for each product with the following information's  - Segment - Artnr. - Article name - Ranking position - Country - Region - Sub-region - Segment And...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi DanielPasalic 

try this

Create new column 

Art nr = LOOKUPVALUE('Table1'[Artnr],'Table1'[Segment],'Table2'[Segment],'Table1'[Country],'Table2'[Country])
 add other commmon field which you want to look up.
 
Similarly calculate Art name using above dax.
 
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.
DanielPasalic's avatar
DanielPasalic
Icon for Helper II rankHelper II
6 years ago

Hi Anonymous 

I did exactly after your recommendation but I get the same message: A table of multiple values was supplied where a single value was expected. 
Please find the photo attached. 

Don't know what to do?