Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
DanielPasalic
Helper II
Helper II

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 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 periodSource Data, previous ranking periodSame columns in both tablesSame columns in both tablesSame columns in both tablesSame columns in both tablesSame columns in both tablesSame columns in both tablesMissing info: Article-nr and Article - same as on photo 1Missing info: Article-nr and Article - same as on photo 1same values in other columnes between those two tables. 

5 REPLIES 5
Anonymous
Not applicable

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.

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?

 

Error.JPG

Anonymous
Not applicable

I think you are creating measure instead of column.


Thanks
Pravin

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

Hi
I did not creating measures but “new column “
Anonymous
Not applicable

@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.

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors