Question : 7 Day Moving Average Profit Formula
Answered by : rui-fj2brd3pa284
7 Day Moving Average = AVERAGEX ( FILTER ( ALL ( 'DateTable' ), 'DateTable'[FullDateAlternateKey] > ( MAX ('DateTable'[FullDateAlternateKey] ) - 7 ) && 'DateTable'[FullDateAlternateKey] > <= MAX ('DateTable'[FullDateAlternateKey] ) ), [Profit]) Source : https://pragmaticworks.com/resources/cheat-sheets/dax-cheat-sheet-page/ | Last Update : Tue, 31 Aug 21