Moving Average (Power BI Report)
APPLIES TO: Generally available in Business Central 2024 release wave 2 (version 25.1).
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.
Use the report
The Moving Average report is meant to help higher level employees identify key trends and 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:
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. To learn more, go to Track your business KPIs with Power BI metrics.
Data used in the report
The report uses data from the following tables in Business Central:
- Value Entry
- Sales Line
Try the report
Try the report here: Moving Average
Tip
If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. In this way, you can stay on the current page while you explore the report on the other browser tab.
See also
Track your business KPIs with Power BI metrics
Ad hoc analysis of sales data
Built-in sales reports
Sales analytics overview
Sales overview