Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculating average on year

Hi all,   as my subject seems very easy to solve, I don't succeed in this. I found already similar topics on this forum and used the formulas mentioned there, but it still doesn't give me the resul...
  • sjoerdvn's avatar
    sjoerdvn
    2 years ago

    Did you add "avg prm" as a computed column instead of a measure? 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for your reply.
I've tested this function but the numbers are the same as the ones for quantity:

 

sjoerdvn's avatar
sjoerdvn
Icon for Solution Sage rankSolution Sage
3 years ago

It isn't clear from your information if that date column is linked to a date dimension table. If it is, you would have to use the month column there in the ALL() function.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    There is no date dimension table involved. The data is loaded from a database and has only a date-column. When loading the data, automatically a date-hierarchy is included.

    In a first attempt I was working with a date-table. As a asking a colleague from help, he told me that he always works with the automatically added date-hierarchy, so thats why I tried to do it like that.

    I still have this 'old' version of my report, I will check if I get other/better results when using the formula there.
    *Update* doesn't work, i get a 'syntax for Month is incorrect'-error ...

    Set-up from the 'old' file: