Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Selected Week from Next 4 week value calculation .

I have table name called Invenoty sheet . this table look like . based on the  wknum selection will show rolling average to next 4 weeks .    (Wknum is text format)     DATE                   ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    You already have a Date table, it is better to use it. Please refer to attached file with the proposed solution

Anonymous's avatar
Anonymous
Not applicable
3 years ago

tamerj1  its working Now perfectly .  I have one more question How to convert above measure  SUM to average ?