Forum Discussion

jackmike's avatar
jackmike
New Member
10 years ago
Solved

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 sta...
Comment
Suggestion
MiguelMartinez's avatar
MiguelMartinez
Microsoft Employee
10 years ago

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.

  • DavidMoss's avatar
    DavidMoss
    Advocate V
    10 years ago

    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's avatar
    lcasey
    Post Prodigy
    9 years ago

    These links dont work!!!

     

     

    • bourquejeff's avatar
      bourquejeff
      Frequent Visitor
      8 years ago

      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.

      • Aztec's avatar
        Aztec
        Frequent Visitor
        8 years ago

        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 !!

  • OzSurferAl's avatar
    OzSurferAl
    New Member
    4 years ago

    Hi Miguel, are you ready to update this post with more specific Power BI examples as yet?