Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 whatever month is selected by users on the slicer/slider. DATESBETWEEN examples I've found only show hardcoded dates, which is useless--this needs to shift dynamically. DATEADD fails due to "contiguous dates" issues.
The simple logic is:
mTotalSalesBetween15Mo&12MoAgo:=CALCULATE([mTotalSales], DATESBETWEEN(-15,-12, MONTH))
Does anyone have any insight? I can't go through another "Finkle and Einhorn" night over something that should be so dead simple.
Solved! Go to Solution.
Found the solution:
SafetyStockMASTER:=CALCULATE([mMASTER1BridgeUnitsSoldHISTORICALandFCST],
DATESBETWEEN(DateMasterDim[DateKey],
MAX (DateMasterDim[DateKey]) -480,
MAX (DateMasterDim[DateKey])-390))
Found the solution:
SafetyStockMASTER:=CALCULATE([mMASTER1BridgeUnitsSoldHISTORICALandFCST],
DATESBETWEEN(DateMasterDim[DateKey],
MAX (DateMasterDim[DateKey]) -480,
MAX (DateMasterDim[DateKey])-390))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
100 | |
76 | |
68 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |