Hi,
I hope you can help me with my query, I have spent all afternoon scouring the internet, and have had no luck.
My problem is:
I have 2 tables, each joined by a primary key in PowerPivot.
There are date columns in each table (both formatted as date):
Table 1: Date customer signed up for a service - column named DateSignUp
Table 2: Date customer placed the first order - column named DateCustOrder
In table 1, there are 9,880 records
In table 2, there are 652 records
I have entered a formula in a column in table 1:
=[DateSignUp]-Table2[DateCustOrder]
the above returns an error message.
The expectation is:
Where a customer has placed an order, the difference in days between the columns DateSignUp and DateCustOrder is displayed and where there hasn't been an order there is simply a blank cell.
For information, the error message is:
The value for column 'DateCustOrder' in table 'Table2' cannot be determined in the current context. Check that all columns referenced in the calculation expression exist, and that there are no circular dependencies. This can also occur when the formula for a measure refers directly to a column without performing any aggregation--such as sum, average, or count--on that column. The column does not have a single value; it has many values, one for each row of the table, and no row has been specified.
Thank-you for reading
I hope you can help me with my query, I have spent all afternoon scouring the internet, and have had no luck.
My problem is:
I have 2 tables, each joined by a primary key in PowerPivot.
There are date columns in each table (both formatted as date):
Table 1: Date customer signed up for a service - column named DateSignUp
Table 2: Date customer placed the first order - column named DateCustOrder
In table 1, there are 9,880 records
In table 2, there are 652 records
I have entered a formula in a column in table 1:
=[DateSignUp]-Table2[DateCustOrder]
the above returns an error message.
The expectation is:
Where a customer has placed an order, the difference in days between the columns DateSignUp and DateCustOrder is displayed and where there hasn't been an order there is simply a blank cell.
For information, the error message is:
The value for column 'DateCustOrder' in table 'Table2' cannot be determined in the current context. Check that all columns referenced in the calculation expression exist, and that there are no circular dependencies. This can also occur when the formula for a measure refers directly to a column without performing any aggregation--such as sum, average, or count--on that column. The column does not have a single value; it has many values, one for each row of the table, and no row has been specified.
Thank-you for reading