Forum Discussion
Solved
Syntax error
Hi, why this VAR - RETURN function is giving me error? It is correct until the first part "VAR_AVG_TL". The second formula is identical except for the standard deviation instead of the average. Than...
Hello,
Try this one
VAR _Avg_TL =CALCULATE(AVERAGE('Merge RPE duration'[TL]),DATESINPERIOD('Merge RPE duration'[Date],LASTDATE('Merge RPE duration'[Date]),-7,DAY))VAR _SD_TL =CALCULATE(STDEV.P('Merge RPE duration'[TL]),DATESINPERIOD('Merge RPE duration'[Date],LASTDATE('Merge RPE duration'[Date]),-7,DAY))VAR _Monotony = DIVIDE(_Avg_TL, _SD_TL)RETURN_MonotonyIf I answered your question, please mark my post as solution, Appreciate your Kudos👍
Idrissshatila
Super User
Super UserHello,
Try this one
VAR _Avg_TL =
CALCULATE(
AVERAGE('Merge RPE duration'[TL]),
DATESINPERIOD('Merge RPE duration'[Date],LASTDATE('Merge RPE duration'[Date]),-7,DAY)
)
VAR _SD_TL =
CALCULATE(
STDEV.P('Merge RPE duration'[TL]),
DATESINPERIOD('Merge RPE duration'[Date],LASTDATE('Merge RPE duration'[Date]),-7,DAY))
VAR _Monotony = DIVIDE(_Avg_TL, _SD_TL)
RETURN
_Monotony
If I answered your question, please mark my post as solution, Appreciate your Kudos👍