DAX = Index and match question

[shophoney]

Hi, I have 2 tables:

SalesGOALSAppend, has LOCATION and SALES GOAL and DATES

EWCHoursBudget, has LOCATION and SALES GOAL and HOURS BUDGET

I would like SalesGOALSAppend to look up in what the EWCHoursBudget are when SALES hit a number.

So if sales at 9100 in SalesGOALSAppend hit $100,000 look up in EWCHoursBudget what the budgeted hours would be.

My sales range is listed in values of about $10,000 so if the sales are between $100,000 and 109,999 then return 400 hours. If it's between 110,000 and 119,999 return the next value which would be 420 hours.

Is this possible?

EWCHoursBudget

location	sales	hours
8000	60000	520
8000	70000	540
8000	80000	590
8000	90000	630
8000	100000	670
8000	110000	710
9000	50000	400
9000	60000	450
9000	70000	550
9000	80000	600

SalesGOALSAppend

LOCATION	DATE	SALES
1000	01/28/19	$37,000
1000	02/11/19	$44,500
1000	02/25/19	$39,700
1000	03/11/19	$62,100
1000	03/25/19	$57,100
1000	04/08/19	$50,100
1000	04/22/19	$63,100
1000	05/06/19	$77,800
1000	05/20/19	$63,400
1000	06/03/19	$34,400
1000	06/17/19	$49,100

 

[CSmith]

A simple VLOOKUP or XLOOKUP should work...