Hi All i have below requirement that For Each Item i have a regular capacity for begin effective date in the Dates table. Some times the Capacity will change for the same Item Number based on the Begin Effective date in the Dates table. Now i have a Fact table with Stock plan date for each Item Number. Here BGN_EFF_DATE and [Stock Plan Date] are not the same dates. But i want the BGN_EFF_DATE to be in the interval range of Stock plan date for each Item No . This will give me a way to combine my Capacity to that of Available Qty for given time period and Item No. Please see below attached QVW file.
Massimo GrossiApp Development If you have few minutes please help on this.
