Fully-functioning Power BI Profit &amp; Loss template with sample dataset (&gt; 300k transactions) that is pre-transformed for use by the template.Try the demo below:<div class="iframe-wrapper"><iframe src="https://app.powerbi.com/view?r=eyJrIjoiNzU5MWQwNWItYTUzMi00NzI3LWE0MTctMTczOTM2ZjYyOGEyIiwidCI6IjA0NmZlOGZmLTMzZWMtNDkzZC1iYjg3LWU2MDY2ZDI1ZjZkNiIsImMiOjh9&amp;embedImagePlaceholder=true" frameborder="0" allowfullscreen="true"></iframe></div>The template is a .pbix file and Excel workbook with pre-transformed accounting data, which means that it is suitable for exploring a data model that is optimised for a P&amp;L report and the use and construction of the various DAX measures in the report. The template is fully-working, and is the basis of numerous live projects.Included features:<ul><li>Six-page income statement report, as per the demo above, plus drill-through and transaction detail tooltip</li><li>Fully-working example of using DAX Dates Measures to provide simple, highly-intuitive selection of dates ranges by the user</li><li>Dynamic matrix columns, based on slicer selection (PY or Budget)</li><li>Budget/PY to Actual Bridge visuals</li><li>YTD-plus view with actuals YTD and the remainder as Budget/PY</li><li>Switch between different Charts of Accounts</li></ul>Suitable forThis template is ideal for someone who wants to explore:<ul><li>An optimised P&amp;L Power BI data model</li><li>Using dates measures with disconnected tables for highly intuitive date range selection</li><li>A four-level Measures model comprising Base Measures, Calculation Measures, Presentation Measures and Filter Measures</li><li>Presentation possibilities around an Income Statement - all using standard, or free 3rd party visuals.</li></ul>Not suitable for In this basic template, the accounting data is provided already transformed and ready for use in the Power BI model. The template is therefore not well suited for adaptation to other accounting data sources and charts of accounts. The Generic and Accounts-specific versions of this template should be used if you want to adapt this to your own accounting data.

Power BI Income Statement Template - fully configurable

P&L plus Balance Sheet Template - with pre-transformed sample data

P&L plus Balance Sheet Template - fully configurable

Power BI Income Statement Template - Sage 50 Accounts

Power BI Income Statement Template with pre-transformed sample data

Intuitive and interactive Power BI Profit & Loss template with sample data. For exploring the possibilities of dates measures and disconnected tables.

Power BI Income Statement Template with pre-transformed sample data

Short Description

Description

Specifications

Related Products

Power BI Income Statement Template - fully configurable

P&L plus Balance Sheet Template - with pre-transformed sample data

P&L plus Balance Sheet Template - fully configurable

Power BI Income Statement Template - Sage 50 Accounts