Conceptual

3-Month Rolling Average in Power BI DAX

The concept describes a time-series smoothing technique known as the moving average (or rolling average), which calculates a central tendency by averaging data points across a fixed window of preceding periods relative to the current observation point. This mechanism relies on defining specific temporal boundaries where the calculation includes the current period and extends backward for $n-1$ units, effectively filtering out high-frequency noise to reveal underlying trends in continuous sequential data domains such as business analytics and statistics. The theoretical significance lies in its ability to decouple short-term fluctuations from long-term patterns, enabling more stable trend analysis than simple point-to-point comparisons within the broader discipline of quantitative data interpretation.