How to Calculate Burn Rate in Power BI with AI

Calculating your business's burn rate is one of the most fundamental financial health checks you can perform. Knowing this number helps you understand how long you can operate before you need more funding - your financial runway. While it sounds complex, creating a dynamic burn rate report in Microsoft Power BI is completely achievable, and its built-in AI tools can help you uncover the story behind the numbers.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

This tutorial will walk you through the entire process, step by step. We'll cover how to prepare your data, use simple DAX formulas to calculate your burn rate, and then leverage Power BI's AI features to analyze the results without needing a data science degree.

What is Burn Rate and Why Track It?

Before we build anything, let's get on the same page about what we're measuring. There are two types of burn rate you should know:

• Gross Burn Rate: This is the total amount of cash your company spends in a given period, typically a month. It includes everything from salaries and rent to marketing spend and software subscriptions.
• Net Burn Rate: This is the most critical number. It’s your Gross Burn Rate minus the cash revenue you bring in during the same period. This figure tells you the actual amount of money your company is losing each month.

If your Net Burn is $50,000 per month and you have $500,000 in the bank, you have a 10-month runway. Tracking this metric in Power BI gives you a live, visual understanding of your financial health, allowing you to make smarter decisions about hiring, spending, and fundraising before it's too late.

Step 1: Get Your Financial Data Ready

Power BI is powerful, but it relies on clean, well-structured data. The classic rule of "garbage in, garbage out" applies here. Your goal is to create a simple table that lists every single financial transaction, both incoming and outgoing.

You can typically export this data from your accounting software (like QuickBooks, Xero), payment processors (Stripe), and advertising platforms (Google Ads, Facebook Ads). Combine them into a single spreadsheet with a structure like this:

• Date: The date of the transaction.
• Category: What the transaction was for (e.g., 'Payroll', 'SaaS subscriptions', 'Office Rent', 'Sales Revenue').
• Amount: The monetary value of the transaction.

Here’s a critical tip: format your data so that expenses are negative numbers and revenue is a positive number. This makes the math in Power BI much simpler down the line. A little prep work here will save you a ton of headaches later.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Calculate Burn Rate Using DAX Formulas

Once your data is clean, it's time to pull it into Power BI Desktop and start building the calculations. DAX (Data Analysis Expressions) is the formula language used in Power BI. It might look intimidating, but we'll stick to a few straightforward formulas.

1. Import Your Data

First, open a blank Power BI report. Go to the Home tab, click Get Data, and choose the appropriate source (likely Excel or CSV). Select your prepared financial data file and load it in.

2. Create a Date Table (Best Practice)

For any time-based analysis, a dedicated date table is best practice. It helps Power BI handle dates correctly. Go to the Data view on the left, then the Modeling tab at the top. Click New Table and enter this DAX formula:

Date Table = CALENDAR(MIN('Financials'[Date]), MAX('Financials'[Date]))

(Be sure to replace 'Financials'[Date] with the name of your table and date column).

After creating the table, go to the Model view and drag the Date column from your Date Table onto the Date column in your Financials table to create a relationship.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

3. Create Core Measures

Now we'll create the building blocks for our burn rate calculation. In the Report view, right-click on your Financials table in the Fields pane on the right, and select New measure.

Total Expenses (Gross Burn)

This measure will sum up all the negative values (our expenses) and display them as a positive number for easy reading.

Total Expenses = CALCULATE(SUM(Financials[Amount]), Financials[Amount] < 0) * -1

Total Revenue

This measure will sum up all the positive values in our Amount column.

Total Revenue = CALCULATE(SUM(Financials[Amount]), Financials[Amount] > 0)

Net Burn Rate

This is the magic number. It's simply expenses minus revenue.

Net Burn Rate = [Total Expenses] - [Total Revenue]

A positive result for Net Burn Rate means you are spending more than you earn (burning cash). A negative result means you are profitable for the period.

Step 3: Visualize Your Burn Rate

Now that you have your measures, you can create a clear and insightful dashboard.

Drag the following visuals from the Visualizations pane onto your report canvas:

• Cards for Key Metrics: Create three cards. Drag Total Expenses into the first, Total Revenue into the second, and Net Burn Rate into the third. These give you an immediate snapshot for the selected time period.
• Line Chart for Trends: Add a Line Chart to the canvas. Drag Date from your Date Table to the X-axis. Drag Net Burn Rate and Total Revenue onto the Y-axis. This visual is powerful for seeing trends. Is your burn rate shrinking or growing? Is revenue climbing fast enough to offset expenses?
• Bar Chart for Expense Categories: Add a Stacked Bar Chart. Drag Category to the Y-axis and Total Expenses to the X-axis. This will instantly show you where your money is going. You can click on "Payroll" or "Marketing," and the entire dashboard will filter to show how that category impacts your overall burn.

Step 4: Use Power BI's AI to Ask "Why?"

Having the numbers is great, but understanding what drives them is even better. This is where Power BI's AI features can help you analyze your burn rate without writing nests of complex formulas.

1. Q&A (Natural Language Questions)

One of the easiest ways to explore your data is by simply asking questions. From the Visualizations pane, add the Q&A visual.

Now you can type questions directly into it, such as:

• "What was our net burn last month?"
• "Show total expenses by category as a pie chart"
• "Highest total expenses for marketing in November"

Power BI will generate a visual to answer your question on the fly. This lets anyone on your team interact with the data and get answers without needing to learn the Power BI interface.

2. The Key Influencers Visual

This is one of the most powerful AI visuals for root cause analysis. Add the Key Influencers visual to your report.

For the Analyze field, drag in Net Burn Rate. For the Explain by field, add columns that might be influencing your burn rate, like Category.

Power BI will then analyze your data and tell you statistically what factors are most likely to increase or decrease your net burn. For instance, it might tell you: "When Category is Payroll, the Net Burn Rate is, on average, $45,000 higher." This instantly confirms your biggest expense drivers, backed by data.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

3. Decomposition Tree

The "Decomp Tree" lets you interactively break down a metric to see its constituent parts. Add this visual to your report.

For the Analyze field, drag in Total Expenses. For the Explain by field, drag in columns like Category, and if you have it, Sub-Category.

You can then start with your total expenses and click through different branches to drill down. You might click on "Marketing" to see it split into "Facebook Ads" and "Google Ads," then click on "Facebook Ads" to see it broken down by campaign. It’s a fantastic way to explore financial data and spot anomalies.

Final Thoughts

Manually tracking your burn rate is a painful process, but building a live dashboard in Power BI gives you constant visibility into the financial health of your business. By structuring your data correctly and using a few simple DAX measures, you can move from static spreadsheets to a dynamic report. Power BI's AI features then let you go a level deeper, turning you into a data analyst who can quickly find the "why" behind your spending.

While Power BI is a great tool, the learning curve for DAX and manual dashboard setup can still slow things down. That's precisely why we built Graphed. Instead of wrestling with data models and formulas, you can connect your financial sources like QuickBooks, Stripe, and ad platforms, then simply ask, "create a dashboard showing my net burn rate and revenue trends for the last 6 months." We automatically generate live, interactive dashboards in seconds, so you can spend less time building reports and more time acting on the insights they provide.