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.?

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.