Answers for "7 Day Moving Average Profit Formula"

0

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])
Posted by: Guest on August-24-2021

Browse Popular Code Answers by Language