Forum Discussion

Valentin09's avatar
Valentin09
Regular Visitor
1 year ago
Solved

Weekly Team Average - Running Data

Hi everyone,   I have the following table: (just the Athlete-Name is missing in the picture!)   And I want the Visual at the end to look like this:   I need a calculation which giv...
  • vivek31's avatar
    vivek31
    1 year ago

    HI Valentin09,

    you can try this formula to find Daily Average for players who particpated full 

    Full avg = AVERAGEX(FILTER(Team,Team[Participation] = "Full"),Team[Distance])

    Weekly Team-SUM for Week you and try this 

    Weekly team = SUMX(VALUES(Team[Date]),[Full avg])

    If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

    Thank you

vivek31's avatar
vivek31
Resolver II
1 year ago

HI Valentin09,

you can try this formula to find Daily Average for players who particpated full 

Full avg = AVERAGEX(FILTER(Team,Team[Participation] = "Full"),Team[Distance])

Weekly Team-SUM for Week you and try this 

Weekly team = SUMX(VALUES(Team[Date]),[Full avg])

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you