DAX Lookup column on same table

Hello

I would like to add a column to a table that looks up a specific value from the same table based on the current row

This works but the values are hard coded and not the values from the current row

=LOOKUPVALUE

( 'Media Invest'[Magazine Page Number];

'Media Invest'[Magazine Name];"MAACW01";

'Media Invest'[Publication Date];20160301;

'Media Invest'[Magazine Insertion Placement];"4C" )

what I want to do is find a specific value in the same table for the magazine name and publication date

This doesn't work

=LOOKUPVALUE

( 'Media Invest'[Magazine Page Number];

'Media Invest'[Magazine Name]; 'Media Invest'[Magazine Name];

'Media Invest'[Publication Date; 'Media Invest'[Publication Date];

'Media Invest'[Magazine Insertion Placement];"4C" )

I could do this in the underlaying SQL view but it's slow Any help is welcome

Thanks David