How do I prevent Structured References from shifting when adding a new column to table imported via Power Query?

[bassplr19]

I have a data table that I query from one shared department spreadsheet. I pull that data into my spreadsheet with Power Query, I don't perform any special steps, just import.

I then reference that DATA[Wire 1] and DATA[Wire 2], for example. If I put a column [Wire 1.5] in between [Wire 1] and [Wire 2] in the source data, my structured reference become DATA[Wire 1] and DATA[Wire 1.5] in my formulas.

How do I prevent this going forward? One thought I had was put "Wire 2" (in B2, for reference) above the column and change my structured reference to indirect("DATA[" & B$2 & "]") but I may want to reference multiple imported columns.

Is there a better way to reference this data?

 

[ExcelToDAX]

Try

DATA[[Wire 1]:[Wire 1]]

 

[bassplr19]

Book1.xlsx
	A	B	C	D	E	F	G	H
1	Wire 14	Wire 10					Wire 14	Wire 10
2	Lug A	Lug B					Lug A	Lug B
3
4
5								Lug B
Sheet1

Cell Formulas
Range	Formula
H5	H5	=Lugs_2[Wire 10]

I then add a column to the first table.

Book1.xlsx
	A	B	C	D	E	F	G	H	I
1	Wire 14	Wire 15	Wire 10					Wire 14	Wire 10
2	Lug A	Lug C	Lug B					Lug A	Lug B
3
4
5									Lug B
Sheet1

Cell Formulas
Range	Formula
I5	I5	=Lugs_2[Wire 10]

I save the workbook and refresh the query, then this happens?

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Wire 14	Wire 15	Wire 10					Wire 14	Wire 15	Wire 10
2	Lug A	Lug C	Lug B					Lug A	Lug C	Lug B
3
4
5									Lug C
Sheet1

Cell Formulas
Range	Formula
I5	I5	=Lugs_2[Wire 15]

 

[bassplr19]

Try

DATA[[Wire 1]:[Wire 1]]

Huh? It did the same things

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Wire 14	Wire 15	Wire 10					Wire 14	Wire 15	Wire 10
2	Lug A	Lug C	Lug B					Lug A	Lug C	Lug B
3
4					Lug C
5									Lug C
Sheet1

Cell Formulas
Range	Formula
E4	E4	=Lugs_2[[Wire 15]:[Wire 15]]
I5	I5	=Lugs_2[Wire 15]