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])
