Forum Discussion

awolf88's avatar
awolf88
Helper II
4 years ago
Solved

Lookupvalue over 2 Columns

Hi girls & guys,   I have 2 very simple tables:  1.) Sales 2.) Product Table   Now as you can see within the Product table, there's one item, "2536" or "TV Remoate", that comes at d...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I suggest creating Product table like below.

     

     

    And then, Range of MIn column and Max column can be used like below.

     

    Please check the attached pbix file. All Calculated Columns are in the attached pbix file.

awolf88's avatar
awolf88
Helper II
4 years ago

Did the trick, beautifully! Thank you kindly!!