Forum Discussion
Anonymous
8 years agoNot applicable
-
-
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
- quentin_vigneSolution Sage
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