Skip to content

My Collection

Of Useful Things

  • custom
  • Cumulative Measures
  • Time Intelligence
  • Averaging Measures
  • Ranking Measures
  • Time Comparison
  • Percent of Totals
  • Core Measures
  • Moving Averages

Category: Time Comparison

SALES LM

December 16, 2022 ~ Dax

SALES LM =

Calculate([Total Sales],

DATEADD(Dates[DATE], -1, Month))

Sales LQ

December 16, 2022December 16, 2022 ~ Dax

Sales LQ =

Calculate([Total Sales],

DATEADD(Dates[DATE], -1, Quarter))

Sales LY

December 16, 2022 ~ Dax

Sales LY =

Calculate ([Total Sales],

SAMEPERIODLASTYEAR(Dates[Date] ))

Blog at WordPress.com.
  • Subscribe Subscribed
    • My Collection
    • Already have a WordPress.com account? Log in now.
    • My Collection
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar