Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Previous Period Average Based On Date Range Selection

Hi Everyone,    I'm a bit stuck on something. I'm trying to find previous period average sales. This on its own i've been able to do, however, where i'm getting stuck is i need to find average sale...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak - I keep getting the same average as the time period selected, rather than the average for the previous period. This is what i'm using: 

 

var average = SUMMARIZE('FactSales', 'Date'[Date], "AverageAmount", SUM('FactSales'[SalesValue])), [AverageAmount])

   return 
      CALCULATE(_average, DATEADD('Date'[Date], -7, DAY))
 
 
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , try like

 

CALCULATE(SUM('FactSales'[SalesValue]), DATEADD('Date'[Date], -7, DAY))