Hi, I am trying to calculate a value

Written by Taryn.

Hi, I am trying to calculate a value in the powerpivot window. I am using the following formula: =tblDeliverable[DateSignOff])-tblRequestDetails[RequestDate] I have changed the date fields to text, and have tried a various number of different ways to do the calculation but nothing works. There is a relationship between the two tables. I get the same error: The value for column 'RequestDate' in table 'tblRequestDetails' cannot be determined in the current context.