Forum Discussion

NWBI's avatar
NWBI
Frequent Visitor
8 years ago
Solved

Deferred Revenue Model

Hello all,   I am building a model to calculate and allocate deferred revenue balances for our accounting team.   I need to take each annual payment, divide that revenue over 12 months, and assig...
  • NWBI's avatar
    NWBI
    8 years ago

    no responses...so sad...good thing I am amazing and ended up solving it myself. 

     

    eliminate the relationship between the date table and the transaction table (original relationship was between date table[Date] & transactiontable[date of transaction]). Create a filter using the date field in the date table to select desired range for bar graph. All 12 months of the deferral period should display amount to be deferred....

     

    thank you me

NWBI's avatar
NWBI
Frequent Visitor
8 years ago

no responses...so sad...good thing I am amazing and ended up solving it myself. 

 

eliminate the relationship between the date table and the transaction table (original relationship was between date table[Date] & transactiontable[date of transaction]). Create a filter using the date field in the date table to select desired range for bar graph. All 12 months of the deferral period should display amount to be deferred....

 

thank you me