Forum Discussion

bosleyjarrett's avatar
bosleyjarrett
Frequent Visitor
9 years ago
Solved

Calculating Moving 90 Day sum and plotting on time graph

Hello,   I am trying to calculate a moving 90 day sum that I am then plotting on a graph with the actual months (think June has June, May & April data, May has March, April, and May data etc). My d...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi bosleyjarrett

     

    This should be close and works for me.  This calculated measure assumes a relationship between the Sales and Dates tables.

     

     

    Measure = CALCULATE(
                    SUM('Sales'[Sales Qty]),
		    -------------------------------------------------------------------------
	            DATESINPERIOD('Dates'[Date],LASTDATE('Dates'[Date]),-90,DAY)
		  )

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi bosleyjarrett

 

This should be close and works for me.  This calculated measure assumes a relationship between the Sales and Dates tables.

 

 

Measure = CALCULATE(
                    SUM('Sales'[Sales Qty]),
		    -------------------------------------------------------------------------
	            DATESINPERIOD('Dates'[Date],LASTDATE('Dates'[Date]),-90,DAY)
		  )

 

  • bosleyjarrett's avatar
    bosleyjarrett
    Frequent Visitor
    9 years ago

    That looks to have worked! Thanks Phil!