Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DATESBETWEEN Dynamic Monthly

I've exhausted myself failing to solve what should almost literally be the simplest DAX measure of my career. I simply want a measure that sums values for the period 15 months to 12 months prior to w...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Found the solution:

     

    SafetyStockMASTER:=CALCULATE([mMASTER1BridgeUnitsSoldHISTORICALandFCST],
    DATESBETWEEN(DateMasterDim[DateKey],
    MAX (DateMasterDim[DateKey]) -480,
    MAX (DateMasterDim[DateKey])-390))

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Found the solution:

 

SafetyStockMASTER:=CALCULATE([mMASTER1BridgeUnitsSoldHISTORICALandFCST],
DATESBETWEEN(DateMasterDim[DateKey],
MAX (DateMasterDim[DateKey]) -480,
MAX (DateMasterDim[DateKey])-390))