Hi All,
I am wondering if its possible to get an average list of created measure.
Basically I have powerpivot flat table that have the following list :
List Measure1 Measure2 Measure3 Measure4 Measure5
aa 3 4 2 0 0
bb 2 1 8 4 2
Would like to have
List Measure1 Measure2 Measure3 Measure4 Measure5 Measure 6
aa 3 4 2 0 0 3
bb 2 1 3 8 2 4
Measure6 = avg( measure1:measure5)
Thanks all
Bookmarks