Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi @Anonymous,
Please refer to this blog to provide more necessary details.
Regards,
Yuliana Gu
Hi @v-yulgu-msft,
Indeed a clearer explanation is needed here.
Please see the table and visual below as I created in Excel with sample data.
1. When you have a new booking, the Total amount is divided by the months left from the new booking month, to the end of the year, (If the booking was on February, Booking RMR =New Booking/11. Same goes for cancellations.
2. Total Monthly Revenue=Previous month revenue+Booking RMR current month+Cancellation RMR current month
3. The bar should then display RMR, New Booking RMR, Cancellation RMR, and Total Revenue each month.
In Excel, once you have a new booking or cancellation, you can easily calculate the impact and "drag" the result to all future months.
Question is how to apply that in Power BI?
You can download the Excel file here
Many Thanks!
Asaf