Commercial Real Estate Financial Model

[chris123456781]

I'm looking to build a very simplistic financial model for commercial real estate in Power BI, with the goal of end users being able to manipulate simple inputs to see the effect of net operating income (synonymous with net income or the bottom line).

For example, if NOI = Revenue - Vacancy - Expenses, I'd like for users to be able to adjust base case assumptions (Revenue, vacancy, expenses, etc.) to see the change in NOI.

Would anyone know of a tutorial similar to the attached youtube link for help? I'm unsure how to "Google it." The tutorial cuts off just before he shows you how to build it out from scratch in Power BI. I'd want to build something similar to the attached screenshot. I understand excel is more powerful for financial modeling but I just want to get something high level for our clients to play around with and utilize the visual prowess of Power BI. Thanks to anyone for assitance.

https://www.youtube.com/watch?v=OwPBMJeY7Og

[DataInsights]

@chris123456781,

You could try numeric range parameters (formerly what-if parameters). They allow users to specify inputs that are used in measures.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if