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

Hi there! 

may I pick up this problem from before and inquire about one more piece of coding to what has worked as a charm so far? 

My Product table now has 2 additional columns with a mix of current and historic prices that have changed due to price increases. I would now need the code to not only aggregate by quantity amount but also by which time window the sales price has been valid for if that makes sense? 

 

Thanks guys!