Forum Discussion
Subscription Recurring Revenue
Hello, I have a data table which is shows a list of transactions. Against each transaction is an annualised revenue figure where we will get this revenue into perpetutity. Data Example: ...
Thank you Anonymous, based on your results that is the outcome I am looking for however it isn't working in my model, I am getting tiny values.
I have updated the tables in your formula to the below. My fact table (Wholesale Actuals) will have about 200,000 transactions every month into a range of funds. Using a mapping table I map these funds to strategies and I would show that on my dashboard, not the individual transaction.
Would I need to use some form of iterating function like sumx to calculate the in month revenue of each transaction and then somehow add on the normal full month of revenue?
Thank you for help.
AnnualisedRev =
VAR vAnnualDate = SELECTEDVALUE('Wholesale Actuals'[Flow Date])
VAR vRevenuePerDay = SELECTEDVALUE('Wholesale Actuals'[Annualised Revenue]) / 365
VAR vFirstDate = FIRSTDATE(Dates[Date])
VAR vLastDate = LASTDATE(Dates[Date])
VAR vDays = DATEDIFF(MAX(vAnnualDate, vFirstDate), vLastDate, DAY)
+ 1 RETURN vRevenuePerDay * vDays