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?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    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's avatar
      DanielPasalic
      Icon for Helper II rankHelper II
      6 years ago
      Hi
      I did not creating measures but “new column “
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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.