Forum Discussion
Anonymous
8 years agoNot applicable
-
-
- 8 years ago
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
quentin_vigne
Solution Sage
8 years agoHi 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