** Update 29/05/2021 – Newer samples are now available on GitHub at https://github.com/ProdataSQL/FinancialModelling
The PBIX is preloaded, so you don;t need to load files, but if you don want to, you will need to change file locations to match where you ahve downloaded files too **
I updated my AdventureWorks Sample Report to include CashFlow, so we now have the three core areas of GL in one PBIX.
- Profit and Loss
- Balance Sheet
- Cash Flow
You can download the PBIX from below link
https://github.com/ProdataSQL/FinancialModelling
To see my sessions on Creating Financial Reports in PowerBI you can drop by previous online seminars such as:
https://sqlbits.com/sessions/event20/Financial_Modelling_with_Power_BI
Hi Bob,
I came across your excellent YouTube vid yesterday and decided that I wanted to deepen my understanding by taking you up on the offer to download the PBIX and source files. However there seems to be an issue with the source files and the Power Query transformations. A key issue was that the PQ transformations in “Financial Report” refer to columns that are not included in the source file (“LineNo”, “LinkLineNo”, and “LinkSignage”). I couldn’t find a way around this so I’m hoping that you will consider looking into this and fix?
I’ve been hoping for a video just like this, where the parent-child pattern from “the Italians” is extrapolated for actual financial accounting. To be fair on Alberto and Marco they do state in their patterns that there are more things to think about before using in management accounting.
In any case – thank you for taking the time!
Regards – Ragnar
Hi,
The sample model is already fully loaded so you shouldn’t need to load the source files. If you do want to you need to change the path of the files to match where you may have downloaded the file to.
Also, I added a new version of the sample reports to GitHub now.
https://github.com/ProdataSQL/FinancialModelling
Best Regards,
Bob
The source files isn’t working. When enter in power query no load correctly
Hi,
The sample model is already fully loaded so you shouldn’t need to load the source files. If you do want to you need to change the path of the files to match where you may have downloaded the file to.
Also, I added a new version of the sample reports to GitHub now.
https://github.com/ProdataSQL/FinancialModelling
Best Regards,
Bob
Hi Bob
I recently came across your financial statement model. It is probably the best I have so far seen. I particularly like the option to switch between different layouts. I tried to apply the same methodology to my own P&L – eventhough my measures are not quite as sophisticated.
As you, I have a simple balance sheet, a P&L and an EBITDA version at the moment. It is a bit embarrassing but I cannot figure out why the balance sheet work, the P&L works works but as soon as I switch to EBITDA the visual goes blank.
I know it is a far cry, but it there any chance you imaging what could cause this?
Best regards
Franz
Hi Franz,
This older model needs TWO spreadsheets with rules populated
1) for the Statement Lines Itself
2) for the mapping of Lines to the GL Code ranges
If you added a new report and its blank, its probbaly missing the second one, or doesnt follow pattern for Line Nos, etc
You can “debug” by looking into the content of the M2M bridging table to check it has rows for the new statement.
Typically start with just Revenue and then work from there.
Hi Bob
Thank you very much for your reply. The debugging helped (besides a very strange behaviour of PBI).
I really appreciate your model. It is a great learning resource. I am yet to figure out how you managed to format the EBITDA% as a percentage in a column of decimals. I have seen others doing it with a Format function but you have not converted to text. Still working on it 🙂
Regards
Franz