# Moving average for sales (Power BI report)
> APPLIES TO: Generally available in Business Central 2024 release wave 2.
The Moving Average report gives a clear picture of your organization's average sales over a 30 day period. Use the report to identify key trends over a set period of time. This report focuses on the sales amount and comparing the current sales amount value against a 30 day average.
![Screenshot of the Moving Average Power BI report]
## Use the report
The Moving Average report can help identify key trends and so you can make changes based on average sales.
Sales executives need to track the moving average of key sales metrics over a specific period. You can use this report to find recent performance trends and make strategic decisions for the short-term future.
Leaders of sales departments typically want to identify which items are selling well and which aren't. This information helps you make informed decisions about your inventory management and future marketing strategies.
## Key performance indicators
The report includes the following key performance indicators (KPIs) and measures:
 sales-powerbi-sales-kpis#sales-lcy
 Sales Amount Average 30D<sales-powerbi-sales-kpis#sales-amount-avg-30d-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:
 Sales Value Entries
 Sales Invoice Lines
 Sales Credit Lines
 Project Ledger Entries
## Try the report
Try the report here: Moving Average<https://businesscentral.dynamics.com?page=37000>
> 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-moving-average, 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-moving-average/
