Lookup values (or other method?) from same table

Hi estewart ,

Sorry for the delay.

For your sceanrio, you could try the steps below.

1. Go to Query editor and duplicate the original table and filter rows with Variable.

2. Apply and Close , create a calcualted column in table 2 with the formula below.

Column = IF('Table2'[Variable] = "Trend_1_Start",1,2)

3.  Create two calculated columns in Table.

Column = IF('Table1'[Variable] in {"Trend_1","Trend_1_Start"},1,2)

Column 2 =
LOOKUPVALUE (
    'Table2'[Value],
    'Table2'[YearQuarter], 'Table1'[YearQuarter],
    Table2[Column], 'Table1'[Column]
)

Here is the output.

More details please refer to my attachment.

Best  Regards,

Cherry