PowerQuery - New Data Messes up Conventional Formula

[tobermory]

Hello,

I have a Table that connects to another spreadsheet, the Table is a merged Table of two other tables. Alongside the table, I have a helper coulmn with convential Excel formula. I know this is shoddy practice, but making the best of a bad job whilst I work on my DAX skills.

Everything works fine, until the data is refreshed. When the data refreshes, the MATCH formula does not look up the corresponding row number.

Before Query Refresh

After Query Refresh

Is there a way to rectify this, so that when I do refresh the data, the MATCH and IF statements lookup the correct row?

Many Thanks

 

[sandy666]

probably you need to connect your table with additional column.
maybe use Power Query for all
sorry but without whole context I can't say more