SALES LM =
Calculate([Total Sales],
DATEADD(Dates[DATE], -1, Month))
Category: Time Comparison
Sales LQ
Sales LQ =
Calculate([Total Sales],
DATEADD(Dates[DATE], -1, Quarter))
Sales LY
Sales LY =
Calculate ([Total Sales],
SAMEPERIODLASTYEAR(Dates[Date] ))