Forum Discussion
Anonymous
3 years agoNot applicable
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 ...
- 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
tamerj1
3 years agoCommunity Champion
Anonymous
Which columns are invloved in the relationship? Is there even a relationship between the two tables?
Anonymous
3 years agoNot applicable
tamerj1 that issues has been fixed but sum values are showing different . I have attached Power bi file for your reference sir
- tamerj13 years agoCommunity Champion
Hi Anonymous
You already have a Date table, it is better to use it. Please refer to attached file with the proposed solution