Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |