cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jackmike New Member
New Member

Traditional Financial Statements

Please don't shoot me, or direct me to SQL SSRS or Management Reporter, but is it possible to create financial statements using Power BI?  Does anyone have samples; balance sheet, profit and loss statement, etc.?  Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Admin
Power BI Admin

Re: 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:

 

I'll make sure to update this post once we have more specific Power BI examples.

Data for Everyone! We mean it
12 REPLIES 12
ashishrj Senior Member
Senior Member

Re: Traditional Financial Statements

@jackmike You can create basic reports using Table or Matrix in Power BI Desktop Tool. 

But major drawback is that we cannot take any printouts for this report neither can we export to any format like PDF/Excel. I don't have a sample to show. 

juan_amucha New Member
New Member

Re: Traditional Financial Statements

Hi, did you get a solution for this? I want to go with all the info into Power BI but I started with the same problem of you and I cant solve it yet

Power BI Admin
Power BI Admin

Re: 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:

 

I'll make sure to update this post once we have more specific Power BI examples.

Data for Everyone! We mean it
DavidMoss Member
Member

Re: Traditional Financial Statements

I must suggest the following series 1,2 & 3 of blog postings to resolve your P&L, BS & CF financial statements.

Though it is a DAX dialogue beyond the scope of PBI blogs.

 

lcasey Member
Member

Re: Traditional Financial Statements

These links dont work!!!

 

 

bourquejeff Frequent Visitor
Frequent Visitor

Re: Traditional Financial Statements

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.

Simba New Member
New Member

Re: Traditional Financial Statements

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? 

rogueneha Frequent Visitor
Frequent Visitor

Re: Traditional Financial Statements

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.

rogueneha Frequent Visitor
Frequent Visitor

Re: Traditional Financial Statements

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.

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 255 members 2,588 guests
Please welcome our newest community members: