How to calculate cumulative Total and in DAX

0 votes

How to calculate cumulative Total and % in DAX in Power BI? I want cumulative for each column after each row for a country along with original rows. can someone help me?

Mar 18, 2019 in Power BI by Anitha
10,467 views

1 answer to this question.

0 votes

Hi,

If your table is ready with percentage field and measure column for performing cumulative total, then follow below steps.

1. Select the sheet you want to apply cumulative total.

 

2. Click on New Quick Measure. Then a dialog box opens, click on running total and select the column ( field ).

3. Click on Ok and Dax code shows up, rename the measure name and click on tick button.

4. Then add the field into the table values.

5. The cumulative total is shown as required now.

Follow the same procedure with % column, the percentage will be given as running total.

Hope this helps you.

answered Mar 18, 2019 by Cherukuri
• 32,890 points

Related Questions In Power BI

0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,850 points
88 views
0 votes
1 answer

How DAX Difference between naked SUM and sum wrapped in CALCULATE?

This is materially different than the question ...READ MORE

answered Oct 8, 2020 in Power BI by Gitika
• 65,850 points
40 views
0 votes
1 answer

How to measure in DAX to calculate YTD for chosen month only for Power BI?

If you use the date column from FactTable, ...READ MORE

answered Dec 22, 2020 in Power BI by Gitika
• 65,850 points
41 views
0 votes
1 answer

How to Transpose unique values and get matching values in rows?

I think this query should do what ...READ MORE

answered Apr 1, 2019 in Power BI by Upasana
• 8,620 points
572 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,220 points

edited Oct 11, 2018 by Kalgi 727 views
0 votes
1 answer

Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 52,290 points
298 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 22, 2019 in Power BI by VNK
16,142 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 52,290 points
25,956 views
0 votes
1 answer

How to show filtered vs total data in power BI?

Hi sindhu, Follow below steps to show filtered ...READ MORE

answered Mar 26, 2019 in Power BI by Cherukuri
• 32,890 points
808 views
0 votes
1 answer

How to categorize state, pin and city in power bi (Address)

After loading dataset, you can split in ...READ MORE

answered May 9, 2019 in Power BI by anonymous
• 32,890 points
709 views