Forum Discussion
Month Forward Coverage
I need help creating a dynamic forward coverage measure. We need to see how many months we have covered for an item. The issue with the current measure below is that its fixed for 2 months/8 weeks. ...
-9 and -1 come from the 8 weeks right? And this has to be dynamic if you choose 4 weeks or 6 weeks, right?
Make a table with the different values: 8,6,4,2 weeks, use it as a slicer and grap the value with SELECTVALUES().