Forum Discussion
MRR Calculation Based on single line Subsciption data
Hi, I am trying to create a montly MRR overview where a measure calculates the sum amount of the subscriptions which are active during that month. Preferable also incorporating half months. Sow w...
Hi Anonymous,
I'd like to suggest you to add an expand table to expand detail records of your table, then you can simply calculate the rolling total amount based on expanding the table.
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
Hi Anonymous,
I'd like to suggest you to add an expand table to expand detail records of your table, then you can simply calculate the rolling total amount based on expanding the table.
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
Thankx! it works. A bit tricky when no months are selected but none the less thanks!