Forum Discussion
Average Last 6 months accumulated
Hello dear community, I come to you so that you can help me with this DAX calculation. I need a Calculated Column to show me: the average of the last 6 months accumulated for each collaborator ...
AVG 6M = CALCULATE( AVERAGEX( DATA, DATA[Compensation] ), DATESINPERIOD( DATA[Date], MAX( DATA[Date] ), -6, MONTH ) )
Muchas gracias CNENFRNL