Forum Discussion

StephaneMA's avatar
StephaneMA
Frequent Visitor
6 years ago
Solved

Moving average based on prior N rows

I am trying to calculate a moving average based on the prior N rows of a table. Something that would match the table below.       I have tried the following but it does not provide the desi...
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    The comma goes before the All().  Try doing just All('Normalized Calendar') instead (remove the column reference).

    Regards,

    Pat

     

  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    StephaneMA colum type is whole number/decimal. Can you copy the table which i shared above and create the same measure (not calculated column) without any  edits. Also share the snapshot.?

StephaneMA's avatar
StephaneMA
Frequent Visitor
6 years ago

I appreciate the help but I do not get the same result at all. I created a new table with the same data to replicate your formula but I get bery different results....

 

 

I am not sure at this point what I am doing wrong to get this result.

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

StephaneMA colum type is whole number/decimal. Can you copy the table which i shared above and create the same measure (not calculated column) without any  edits. Also share the snapshot.?

  • StephaneMA's avatar
    StephaneMA
    Frequent Visitor
    6 years ago

    That did it.......!

     

    Thank you nandukrishnavs.

     

    There must be something wromng with the original dataset. I will fix that issue now that I have a working average working!

     

    I really appreciate your assistance.