Forum Discussion

tangerinemdr15's avatar
tangerinemdr15
Icon for Helper I rankHelper I
5 years ago
Solved

Deferred Revenue - Help with DAX Please!

Hi! I need to recognize the Charge Amount in Appropriate month evenly throughout the year.   Here is an example of the raw data: RIS & RAL Annual Bill + RIS Monthly       BL_DT BL_CHRG_A...
Help
new user
  • tangerinemdr15's avatar
    tangerinemdr15
    5 years ago

    littlemojopuppy 

    Thank you so much for taking the time to help me! With your help, I was able to figure out the calculate function and It was helpful to make that new "Monthly Billing" measure. This is where I landed:

    RIS Monthly Deferred = (TOTALYTD(CALCULATE('RIS & RAL Annual Bill + RIS Monthly'[MonthlyBilling2]/12),PREVIOUSMONTH('RIS & RAL Annual Bill + RIS Monthly'[Month Start Date])))
     
    Thank you so much!
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

tangerinemdr15 - What is the logic for the black amounts? Sorry, I'm not understanding how those amounts should be calculated.

tangerinemdr15's avatar
tangerinemdr15
Icon for Helper I rankHelper I
5 years ago

Greg_Deckler  

Hi! the logic for the black amounts is to take 1/12th of the billing charge amount for the remaining months of the year. For example, the charge that came in on 3/31/20 for $1000. $250 of it was recognized in March.  $1,000 * (3/12)= $250. From April through the rest of the year, 1/12th will be recognized each month.

$1,000 * (1/12) = $83.33

 

Thank you in advance for taking a look!