Forum Discussion
Helper IIFill 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 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.
5 Replies
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.
DanielPasalicHi 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?
