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