Forum Discussion
tangerinemdr15
Helper I
Helper IDeferred 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...
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!
tangerinemdr15Helper I
Helper IThank 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!
littlemojopuppy
Community Champion
Community Championtangerinemdr15 you're welcome...glad I could help! My inner accountant enjoyed it! 🙂