Dax

Hi,  I can try and make it clearer.

The last column (check col) contains a unique reference number, for the start and end of the data needs to be looked at.

Between these two rows  (i.e. in Check Col, there is 5220 through 5227).

Starting row with reference 5220, Ultimate Trade route contains 'Indian Sub Cont & Middle East to Far East'.

5221 is blank, so can be ignored

5222 trade 2 column has 'via Sub Saharan Africa'

5223 is blank, therefore ignored

5224 trade 2 column has 'via Indian Sub Cont & Middle East'

5225 trade 2 column has 'via Far East'

5226 is blank

5227 is blank, but PortCheck2 contains 'VoyEnd', so I need to join the contents of 'Ultimate Trade Route'' (at 5220) to the contents of colum Trade 2 (at 5222 and 5224 and 5225 and 5227), but only for the rows between 5220 and 5227.  The next set of rows will start the process again.

If the final result needs to be in a different column, that's fine.

This is being done using Dax in a powerpivot worksheet, and the results will be used as a filter in a Pivot table.

If this is more suitable to an SQL query, then I can look a that, but it will set me back!  (Not that I am making any headway at the moment).

Thanks,

Dom