Is it possible to build a financial model in Power BI?

[UsePowerBI]

Hello

Is it possible to build a financial model in Power BI?

I am refering to the widely used financial models that calculate cashflows or NPV etc by having future projections of revenues, costs etc.

Is that something doable in PowerBI and would it be preferred than building the model in Excel?

One issue I see is that you cannot easily change inputs of the model in Power BI.

Thanks!

[aj1973]

@UsePowerBI 

You may want to take a look at this

Microsoft Power BI

[Anonymous]

I have built few models on Power BI and yes it is possible to build a model on Power BI, Power BI is a beautiful tool that can be shared with clients and for the first time, our financial models will even be better deliverables to our clients than our reports that we provide on PDF or PowerPoint.

[Fowmy · Accepted solution]

@UsePowerBI 

Excel has more flexibility in terms of managing the inputs and the cell to cell calculation for financial modeling projects than Power BI. 

Power BI supports Parameter values to simulate and produce different scenarios based on user selection but limited when compared to Excel.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn