topic Re: Fill a missing data in column based on a value in another column in DAX Commands and Tips

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

DanielPasalic — Mon, 20 Jan 2020 01:39:23 GMT

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 same values in other columnes between those two tables.

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

Anonymous — Tue, 21 Jan 2020 11:18:02 GMT

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.

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

DanielPasalic — Tue, 21 Jan 2020 17:47:46 GMT

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?

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

Anonymous — Tue, 21 Jan 2020 17:51:41 GMT

I think you are creating measure instead of column.

Thanks
Pravin

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

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

DanielPasalic — Tue, 21 Jan 2020 20:15:09 GMT

Hi
I did not creating measures but “new column “

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

Anonymous — Wed, 22 Jan 2020 07:52:42 GMT

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.