Help with a 'complicated' measure

hi Lin,

Thanks for your help........

So the released amounts and dates are in the bottom table (Paid Date).  So what we need to do is to match the 'Item No' and the 'Date Withheld', to obtain the 'Date Paid' and the '% Paid'

Then with this data one needs to go back to the main data set and look up what the 'Value' was for this Item - in this case it will be  456.00

Then we need to work out for the 1/12/18 that 10% was paid - i.e. 45.60 and this figure needs to show up in the 1/12/18 column.

Does that make sense?

Kind regards

Tim