7 Day Moving Average Profit Formula
7 Day Moving Average =
AVERAGEX (
FILTER (
ALL ( 'DateTable' ),
'DateTable'[FullDateAlternateKey] > ( MAX ('DateTable'[FullDateAlternateKey] ) - 7 ) &&
'DateTable'[FullDateAlternateKey] > <= MAX ('DateTable'[FullDateAlternateKey] )
),
[Profit])