Using measures for Date column rather than Index col for row context

[Jarvis]

Hi Jarett

Thank you very much for your support.

In the link below, the working on EMA has been solved.

How to calculate Exponential Moving Average to show Fitness and Fatigue

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…

Request your help you solve this last leg. Looking forward to your solution to help us calculating the Moving average and EMA. The outcome similar to EMA in the last col of the enclosed sheet.

Regards
Jdata.xlsx (11.3 KB)