Forum Discussion

CESARPULIDOGDL's avatar
3 years ago
Solved

LOOKVALUE NEAREST : Nearest value based on other columns values

Hi,     i nees your help.  I have 2 tables,   the fist is the tableA: kardex of amount of a credit line (profiles of credit card limits):     the second its tableB: de average purschase ...
  • johnt75's avatar
    3 years ago

    You could create a column in TableB like

    Credit Limit =
    VAR AvgPurchase = 'TableB'[Average purchase]
    VAR Result =
        CALCULATE (
            MIN ( 'TableA'[Credit line amount] ),
            'TableA'[Credit line amount] >= AvgPurchase
        )
    RETURN
        Result