Add column to identify group by data range

[nj-matt]

I have 2 tables - promotions and ROI ranges.

I would like to identify the promotions by the range in the ROI range table.

promo_groups

Promotion ID	ROI
A1234	1.50
A1235	1.25
A1236	1.05
A1237	0.88

ROI Performer Ranges

Promo Type	Min	Max
Higher Performer	1.40	2.00
Average Performer	1.20	1.40
Low Performer	1.00	1.20
Non Performer	0.00	1.00

I want to add a column to my promo_groups table to now look like this -->

Promo ID	ROI	Promo Type
A1234	1.50	High Performer
A1235	1.25	Average Performer
A1236	1.05	Low Performer
A1237	0.88	Non Performer

What is the formula to bring in this new colum to the promo_groups table?

[AlB · Accepted solution]

@nj-matt 

Calculated column for your Table1:

Promo Type =
CALCULATE (
    DISTINCT ( Table2[Promo Type] ),
    FILTER ( Table2, Table2[Min] <= Table1[IDROI] && Table2[Max] > Table1[IDROI] )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[nj-matt]

That did it - thank you!