Forum Discussion
Traditional Financial Statements
We are workinf really hard to create content relevant for specific roles and industries but the advantage of Power BI and Desktop is it's similar experience with PowerPivot in excel for modeling. use cases for financial statements has been widely covered by Excel experts on PowerPivot and they're all relevant to Power BI, including DAX code to create relevant measures, calculations and tables. Here are some examples:
- Powerpivot finance reports for P&L
- How Powerpivot can help financial reporting
- Powerpivot Pro financial posts
- Excel financial sample you can import into Power BI Desktop (model)
I'll make sure to update this post once we have more specific Power BI examples.
These links dont work!!!
Yes, we have created Income Statements by Period and Totals against previous year actuals and budget versions in Power BI for our clients based on data sourced from GP. The DAX, as noted in earlier replies, is a bit on the complex side - too much so to go into here. Basically, the data model must be set up with "Account Headers", "Subheaders" and on down the hierarchy, with some headers tied to specific measures to allow for calculated measures in line with previous line items in the Income Statement.
bourquejeff , can you please provide more information on how did you managed to create " Income Statements by Period and Totals against previous year actuals and budget versions in Power BI" ?
Appreciate solutions and advices from the community as well !!
Hi!
Imke, from The BIccountant developped some solutions with PowerBI for the P&L etc.
It takes quite some work to implement it, but if you are looking for a solution that can handle lots of accounts i can only recommand it. Here is a part of her blog on that topic (there are several parts)
Cheers.
G.
What detail did you start with in order to create an income statement, for example? Did you start with amounts per general ledger account? If so, where did you define the hierarchy?
can you explain more on how were you able to create hierarchies and totals and calculations from fields in Power BI for financial reports like P/L, BS, CA etc.?
Some examples will be helpful too as I am not very familiar with DAX expression.
can you explan how you were explain to create hierarchies, totals, calculations from summerized fields for financial reportings like P/L, BS, CA etc.
Some examples will help a lot as I am not very familiar to DAX expressions.
can you explan how you were explain to create hierarchies, totals, calculations from summerized fields for financial reportings like P/L, BS, CA etc.
Some examples will help a lot as I am not very familiar to DAX expressions.
