Forum Discussion

tkfisher's avatar
tkfisher
Frequent Visitor
4 years ago
Solved

Lookup Result Based on Range from Another Table

Hi All,   Need some help on a Calculated Column I am trying to create. I have two tables, one called 'sales', which is used in this DAX formula to calculate a sales order line level sales price (Co...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Could you please try the below for creating a calculated column?

     

    Line Price Level =
SUMMARIZE (
    FILTER (
        'Price List Updated',
        'Price List Updated'[Item Number] = 'sales'[ItemNumber] --           && NOT ISBLANK ( sales[Line ASP] )
            && sales[Line ASP] >= 'Price List Updated'[Lowest Price]
            && sales[Line ASP] < COALESCE ( 'Price List Updated'[Highest Price], 999999 )
    ),
    'Price List Updated'[Price Level]
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

Could you please try the below for creating a calculated column?

 

Line Price Level =
SUMMARIZE (
    FILTER (
        'Price List Updated',
        'Price List Updated'[Item Number] = 'sales'[ItemNumber] --           && NOT ISBLANK ( sales[Line ASP] )
            && sales[Line ASP] >= 'Price List Updated'[Lowest Price]
            && sales[Line ASP] < COALESCE ( 'Price List Updated'[Highest Price], 999999 )
    ),
    'Price List Updated'[Price Level]
)