How to Calculate Recognized Revenue

[jrdavis64]

Hello,

I work for a service organization and am attempting to calculate recognized revenue.  Due to my companies dispersed data systems I cannot pull all of the detail i need from our revenue table and instead need to pull contract details from the Orders table and then calculate the Recognized Revenue based on the Order data.  I have contract start date, end date, and contract value.  I have created calculated columns to determine active contract, contract revenue days, and daily contract revenue.  I am having difficulty creating the final calculate column for recognized revenue which references the prior columns i created for Daily Contract Revenue and Active Contract Days.  The error I am getting is a circular reference error.  I have tried to create measures instead of caluclated columns but I need this to be a the row level.  

Any feedback or help pointing me in the right direction would be greatly appreciated.

[Greg_Deckler]

No, but seriously, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490