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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try a trailing 7 days measure. But use date table with that

 

Trailing 7 days =CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-7,DAY))

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