How to calculate Exponential Moving Average to show Fitness and Fatigue

DAX DAX Calculations
1

Hi All,

I’m trying to recreate the Exponential Moving Average Calculation in Training Peaks using the TSS Score.

For fitness you need to take the Exponential Moving Average for the past 42 Days

For Fatigue you need to take the Exponential Moving Average for the past 7 days.

I feel I am close as I already have the pattern for a 42 and 7 day Day moving Average. Just need to change this to Exponential.

Fatigue (ATL) = 
AVERAGEX(
	DATESINPERIOD( Dates[Date],
		LASTDATE( Dates[Date] ),
		-7, DAY ),
		[Total TSS] )

Fitness (CTL) = 
AVERAGEX(
	DATESINPERIOD( Dates[Date],
		LASTDATE( Dates[Date] ),
		-42, DAY ),
		[Total TSS] )

The only other thing I need help for is to calculate Form (TSB) which is the balance of TSS equal to yesterday’s fitness minus yesterday’s fatigue.

Here’s an export of my data from Training Peaks with the TSS Scores of my training.

workouts 2017.csv (9.0 KB)