Forum Discussion

gerardotrejogcg's avatar
gerardotrejogcg
Helper I
5 years ago
Solved

Cummulative Average

  I have a cost table per week of year (page filtered by this year).   I want to set the cummulative average per week. LT 2 - 95.4 LT 3 -  89 ( [95.4+82.6] / 2) LT 4 -  88.8 ( [95.4+82.6+88...
  • amitchandak's avatar
    amitchandak
    5 years ago

    gerardotrejogcg , Try a new column like

     

    averageX(filter(allselected(Table), Table[segement]= max(Table[Segment]) && Table[Week] <= max(Table[Week])),Table[Value])

     

    in place of this column Table[Value], you can use a measure too

     

    I have assume week on column of matrix

amitchandak's avatar
amitchandak
Super User
5 years ago

gerardotrejogcg , Try a new column like

 

averageX(filter(allselected(Table), Table[segement]= max(Table[Segment]) && Table[Week] <= max(Table[Week])),Table[Value])

 

in place of this column Table[Value], you can use a measure too

 

I have assume week on column of matrix