Forum Discussion

brahweiz's avatar
brahweiz
Regular Visitor
5 years ago
Solved

Cumulative sum with time-intelligent slicer

Hi, I'm new to Power BI, and I'm working on this measure to show cumulative sum on specific time period. The case and what I want: I have one Calendar table [DateKey], and main data table [Data], ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Use this measure

    Cumulative sum 1 = CALCULATE(SUM(Data[Revenue]),DATESMTD(DateKey[Date]))
    Hope this helps.
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Any particular reason for not using the built-in functions like TOTALMTD() ? Of course there are many ways to write that measure, but maybe start with the standard functions.  Power BI offers "Quick Measures" that cover a wide range of frequently used patterns.