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!
littlemojopuppy
Community Champion
Community Championtangerinemdr15 here's your measure. It assumes you have a date table and it is marked appropriately...
Billing = SUM('Raw Data'[BL_CHRG_AMT])
Monthly Billing Amount =
CALCULATE(
[Billing] / 12,
FILTER(
'Raw Data',
'Raw Data'[BL_TYP_TXT] = "Monthly"
)
)The measure for [Billing] is also used in the check table above.
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
tangerinemdr15 you're welcome...glad I could help! My inner accountant enjoyed it! 🙂