PowerBI Pro Forma Financials: Modelling Beyond Excel | Part 1

[@UlyssesHaq]

Invaluable resource! Thanks for sharing and providing a learning platform. Looking forward to more!

[@enoesy9288]

Nice one. Thanks for sharing. Id love to go further with this model. Hope you will make more video like this one.

[@Ptarmy_]

Thanks!

[@Alvaro-bx6jl]

Could you make a similar video where you go into a more complex model that allows you to drill down in your income statement to the month level?

[@mogarrett3045]

excellent video Sir

[@Ptarmy_]

Thanks Mo!

[@mogarrett3045]

right on @@Ptarmy_

[@richardwong6369]

This is very good. Will you extend it out to balance sheet and cash flow?

[@Ptarmy_]

Thanks Richard - am working on those now

[@Ptarmy_]

New videos up Richard. Balance sheet is a long one but some good tips in there.

[@juancarlosesguerra9304]

this looks great! the only thing i didn't get is how you establish an order for the measures, i.e how you get to make net income appear below gross profit

[@juancarlosesguerra9304]

.... actually i couldn't get the SWITCH and SELECTEDVALUE formula to work. could you maaybe expand on that a little in another video, or perhaps by email?

[@Alvaro-bx6jl]

Could you make a similar video where the model allows you to drill down to the month level instead of year?

[@AhmedElShafeey]

again i couldent sort and the job not done, is there any thing related to the PBI app update?!

[@MrAammy]

With the help of this video , I have managed to construct P&L and BS and going forward for the 5 years forecast. it is silly to ask but may i ask how can we remove the grand totals of rows and columns. thanks

[@MrAammy]

Hi I love your video .. to the point. Thanks. Can you please recommend higher level training in BI ? Thanks

[@Ptarmy_]

Thank you. I have not found powerbi training that goes deep into it being applied for finance and accounting real world use cases, for that reason I am working on building a training program in 2024. Good luck in your learning and hope it can help you when I roll it out.

[@MrAammy]

I can not download the files even joking your website. I also confirm the subscription on the email received by PTArmy . Anything else to do to get it downloaded ? Please advise

[@Ptarmy_]

@@MrAammy Check your email, sent you a direct link. I have a second opt in you have to click to confirm you aren't a bot, that may be where you are getting hung up

[@MrAammy]

Once again thank you for the templates . How can we set up different growth % for different regions ?