Forum Discussion

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous there are many posts for moving average, here is link to one. hope it helps.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks parry2k,

      I think this might help some. But my main question is if it is possible to calculate this average of a measure that is set to only calculate the efficiency for yesterday's values, which is done using TODAY()-1. I recently tried using a calulated column but the value was not as accurate as I would like.

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        Anonymous yes you can always to for yesterday. You need to add Measure not column,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    No wonder it does not work... Please try to first learn about how to work properly with time-intelligence functions (www.sqlbi.com could help). DATESINPERIOD does not work on any table that has a column of dates. Also, measures should not really be tied to TODAY(). They should work with any date from a properly built Date table.

     

    Best

    Darek