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.
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Use this measure

Cumulative sum 1 = CALCULATE(SUM(Data[Revenue]),DATESMTD(DateKey[Date]))
Hope this helps.