Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

-

 

  -

 

  • Hi Anonymous

     

    You can use this as a measure : 

    Moving Average = 
    		AVERAGEX(
    			DATESINPERIOD(
    				'Task Calendar'[Task Date],
    				LASTDATE('Task Calendar'[Task Date]) ,
    				 -30 , 
    				 DAY),
    			CALCULATE(sum('YourTable'[Task Count]))
    			)

     

     

     Maybe the , won't work, replace them with ; (In my version of PBI i need to use ';')

     

    - Quentin

1 Reply

  • Hi Anonymous

     

    You can use this as a measure : 

    Moving Average = 
    		AVERAGEX(
    			DATESINPERIOD(
    				'Task Calendar'[Task Date],
    				LASTDATE('Task Calendar'[Task Date]) ,
    				 -30 , 
    				 DAY),
    			CALCULATE(sum('YourTable'[Task Count]))
    			)

     

     

     Maybe the , won't work, replace them with ; (In my version of PBI i need to use ';')

     

    - Quentin