Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Trend Analysis

I am trying to evaluate sales trends in a particular geographical area (city) within a particular timeframe (usually 30 days) based on a particular event. I.e. if a sale is made to a particular entit...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You have try meaures like

Rolling 30 day = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX(Sales[Sales Date]),-30,Day))

or
Rolling 30 day = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX(Sales[Sales Date]),-30,Day), allexcept(Sales,sales[region]))

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.