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 “