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

    Have a WordPress.com account? Log in now.

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