Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Arithmetic sequence with slicer

Hello group!

 

Few days I am trying to solve a problem of how to create "calculated column" and make an average from it but no success yet.

MIndex is column what I need to be sliced by date. I need an average of aritmetical sequence of total count of sliced rows.

Here is an example

 

I probably know how to create a sequence 1,2,3,4,..X but dont know how to sum and average it 

measure = GENERATESERIES(1,COUNTROWS('Transactions - Sell'),1)
 
Thanks for any help 🙂
Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Read about the new windowing functions, specifically INDEX.  And then you should be able to apply a MEDIANX to the result.