Forum Discussion

2 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Super User
    3 years ago

    bansikpopat 
    >> First you need both table in uniq id/index column then you can use LOOKUPVALUE and other Formula .
    for i.g.

    New Column UnitPrice =
    var ids = 'Table A'[Index]
    VAR Result = CALCULATE(MAX(Table B[UnitPrice]),Table B[Index]=ids)
    Return
    Result
    • bansikpopat's avatar
      bansikpopat
      Frequent Visitor
      3 years ago

      Material id is the unique id between the tables. Can I not do anything with that? 

      Also,  I tried to understand above solution but I was not able to get it. I looked up index columns on internet but it did not make much sense. 

      New to writing queries with powerBI.