Home > OS >  Pbi company how to implement the monthly cumulative sum?
Pbi company how to implement the monthly cumulative sum?

Time:09-16

Cumulative GMV=CALCULATE (SUM (' orders' sales GMV []), the FILTER (ALL (DateDimension), 'DateDimension [DateKey] <=MAX (' DateDimension [DateKey])))

As above was written by my measurements, but the result is a cumulative history, if not the accumulated across the month, could you tell me how to write a monthly cumulative measurements?
  • Related