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

[DanielPasalic]

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 many other columns. 
In total 3 012 raws. 

In another table, which is also ranking data but for the new period I don't have
- Art nr
- Article name

Same information's between those two tables are:
- Country
- Region
- Subregion
- Segment
- and Segment. 

How I can fill the columns with missing pieces of information (article number, article name) based on the Source Data, previous ranking periodSame columns in both tablesSame columns in both tablesSame columns in both tablesMissing info: Article-nr and Article - same as on photo 1same values in other columnes between those two tables. 

[Anonymous]

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]

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?

[Anonymous]

I think you are creating measure instead of column.


Thanks
Pravin

If it resolves your problem mark it as a solution and give Kudos.

[DanielPasalic]

Hi
I did not creating measures but “new column “

[Anonymous]

@DanielPasalic 

Your attached screenshot is not clear.

Please check your Dax once again, may be somewhere you have not closed  any brackets.

Art nr = LOOKUPVALUE('Table1'[Artnr],'Table1'[Segment],'Table2'[Segment],'Table1'[Country],'Table2'[Country])

first check this much of dax and then try to add remaining columns.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.