Absolute reference Power Query

[dmax17]

Hi,

Is there a way to make a reference to a cell in a power query sheet absolute?

=INDEX(CountVendorByCategory[NC.SumOfTransactionAmount],MATCH($A$2,CountVendorByCategory[IntCategory],0))

I need to make "CountVendorByCategory[IntCategory]" absolute in the above Index/Match function

Thanks

 

[ImkeF]

Hi,
this looks like plain Excel. Where's the power query element?