# Month-to-date sales (Power BI report)
> APPLIES TO: Generally available in Business Central 2024 release wave 2.
The Month-to-Date (MTD) report helps executives and managers monitor sales revenue for the current fiscal month. It accumulates sales from the start of the fiscal month through the last date in the current date context.
> NOTE
> The figures depend on the data available at the last semantic model refresh and the report's date filters. The MTD calculation doesn't automatically exclude the current date.
![Screenshot of the Month-to-Date (MTD) Power BI report]
## Use the report
Leadership and management teams use the report to monitor sales growth per month.
Business leaders use the report to view the organization's sales performance for the current month. This report offers an easy way to monitor sales revenue progress from the beginning of the month up until the current day. By analyzing the sales figures for the current month and previous months, you can identify trends and make strategic decisions for your organization. With this information at your fingertips, you can make data-driven decisions that help you optimize your sales strategy and drive revenue growth for your business.
Sales managers can use the report to analyze and compare the organization's current sales performance with previous years. The gross profit figures can provide a broader context for the current sales performance. The report also shows a breakdown of sales contributions from top customers. The breakdown lets you identify which customers your team should focus on and maintain good relationships with to improve their sales performance. With these insights, you can guide your team better and take actions to improve their sales.
## Key performance indicators
The report includes the following key performance indicators (KPI) and measures:
 sales-powerbi-sales-kpis#sales-lcy
 sales-powerbi-sales-kpis#sales-amount-mtd-fiscal
 sales-powerbi-sales-kpis#gross-profit-mtd-fiscal
Click on the link for a KPI to learn more about what it means, how it is calculated, and what data was used in the calculations.
> TIP
> You can easily track the KPIs that the Power BI reports display against your business objectives. See Track your business KPIs with Power BI metrics<track-kpis-with-power-bi-metrics>.
## Data used in the report
The report uses data from the following tables in Business Central:
 Sales Value Entries
 Sales Invoice Lines
 Sales Credit Lines
 Project Ledger Entries
 Customer
## Try the report
Try the report here: Month-to-Date<https://businesscentral.dynamics.com?page=37003>
> TIP
> If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.
## Related information
Track your business KPIs with Power BI goals<track-kpis-with-power-bi-metrics>
Ad hoc analysis of sales data<ad-hoc-analysis-sales>
Built-in sales reports<sales-reports>
sales-analytics-overview
Sales overview<sales-manage-sales>
Find free e-learning modules for Business Central here<https://learn.microsoft.com/training/dynamics365/business-central>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/sales-powerbi-month-to-date, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/sales-powerbi-month-to-date/
