9L Cases (Incl DTC) MTD LY
This measure compares the same month as the Current MTD but for the previous year. The end date determines the month last year, with the start date set to the first day of that month. Measures labeled with 'MTD LY' are influenced by the end date and any applied filters.
Formula
m₁
with:
m₁ = Sum([Depletions].[Cases 9L Sold])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
Additional Details
Output Format: #,##0.00
Created: 2024-11-14T16:08:52Z
Last Updated: 2024-11-14T16:17:52Z
Key:
[calculation].[9L Cases (Incl DTC) MTD LY]
Tags
9L Cases (Incl DTC) MTD LY
Cases 9L Sold
Invoice Date