How to Calculate Moving Average in Tableau without using WINDOW_AVG

The ability to calculate moving average across various dimensions provides useful insights into business reports. Comparing values for a particular period with a moving average can help identify discrepancies, or we can even create dependent calculations for Shrink to measure Inventory data to account for fluctuations.

☕ Buy me a coffee! 🙏 Glad my article helped you!

Tableau provides the ability to perform Moving Average calculations easily. The old method was to create a calculated field like WINDOW_AVG(SUM([Sales]), -5, 0) to calculate the Moving Average for last 6 months, however with the latest versions we can achieve the same like below.