CODEWITHSUNDEEP
powerbidax
Yaswanth
Yaswanth

Reputation: 58

How to calculate cumulative sum for day wise in DAX?

enter image description here

Column Names : MonthName,Day,Start,Today,Progress,(LastColumn Is Unnecessary)

Output:

Here i want the cumulative sum of Progress.. i.e., For October 1 - Sum should be 0.00% For October 2 - Sum should be 0.00+3.67% = 3.67% For October 3 - Sum should be 3.67%+2.75% = 6.42%

In this way i want cumulative sum. Help me in this context.

Best Regards, Yaswanth.

Upvotes: 0

Views: 1952

Answers (1)

haoran zhang
haoran zhang

Reputation: 51

power BI Matrix can do that. Follow the below steps:

  1. Under your Matrix visualization, go to your value and select "New quick measure".
  2. Under the calculation list, select "Running Total".
  3. Change field to your "Day" column and click "OK"

Then you should able to see what you want.

enter image description here

Upvotes: 1

Related Questions