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: Cumulative Measures

Cumulative Sales LQ

December 16, 2022 ~ Dax

Cumulative Sales LQ =

//Using Measure Sales LQ

Calculate ([Sales LQ],

Filter(AllSelected(Dates),

Dates[Date] <= Max(Dates[Date])))

Cumulative Sales LM

December 16, 2022 ~ Dax

Cumulative Sales LM =

//Using Measure Sales LM

Calculate ([Sales LM],

Filter(AllSelected(Dates),

Dates[Date] <= Max(Dates[Date])))

Cumlative Sales LY

December 16, 2022 ~ Dax

Cumulative Sales LY =

//Using Measure Sales LY

Calculate ([Sales LY],

Filter(AllSelected(Dates),

Dates[Date] <= Max(Dates[Date])))

Cumulative Sales

December 16, 2022 ~ Dax

Cumulative Sales =

Calculate ([Total Sales],

Filter(AllSelected(Dates),

Dates[Date] <= Max(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