MQ - Add dynamic column that adapts to query output

[Djibril69]

Hello all,

I developed a code in Microsoft Query and would like to add a dynamic column in the worksheet.
This column contains a formula which results in 1 if the value in cell A2 is different from the value in A1, if A3 is different from A2, and so on.
At this moment, I need to drag this formula (=IF(Table_Query_from_CPKD[@[LOCATION_ID]]=A2;0;1)) to the end row of the query output.
I'd like to automatize this such that this column evolves dynamically along with the output of the query.

Would this be feasible and yes, how can I implement this please?

Thanks in advance for your help!

[dflak]

MS-Query returns the data to an Excel Table and Excel Tables should copy down a formula automatically. One suggestion, instead of the table reference try using the cell reference, =IF(A1=A2,0,1)