Forum Discussion

awolf88's avatar
awolf88
Icon for Helper II rankHelper 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.

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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.