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

    Have a WordPress.com account? Log in now.

  • My Collection
    View site in Reader
    Manage subscriptionsSign upLog in
    Report this content
    Collapse this bar