Forum Discussion

vincenzorago's avatar
vincenzorago
New Member
3 years ago
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...
Need Help
Tips and Tricks
  • Idrissshatila's avatar
    Idrissshatila
    3 years ago

    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
        _Monotony
     

    If I answered your question, please mark my post as solution, Appreciate your Kudos👍

    Follow me on Linkedin

lukiz84's avatar
lukiz84
Memorable Member
3 years ago

missing ")" before "VAR _Monotony..."