To calculate conditional running total in power query

0 votes
Is it possible to calculate conditional based running total in power query?

So, I needed to calculate the cumulative sum based on the group.

I'm using a formula to calculate that in sheet and loading it to query editor.

I was wondering if there is any other logic to achieve that in power query (if possible, without indexing?
Apr 26, 2019 in Power BI by Upasana
• 8,620 points
946 views

1 answer to this question.

0 votes

Try Table Buffer after adding the index, or stage data in an Excel table.

answered Apr 26, 2019 by Shubham
• 13,450 points

Related Questions In Power BI

0 votes
1 answer

To Calculate the Standard Deviation in Power BI

Suppose you've to obtain the Standard Deviation ...READ MORE

answered Nov 26, 2018 in Power BI by Upasana
• 8,620 points
7,645 views
+3 votes
1 answer

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 32,490 points
37,383 views
0 votes
1 answer

How to calculate cumulative Total and % in DAX?

Hi, If your table is ready with percentage ...READ MORE

answered Mar 18, 2019 in Power BI by Cherukuri
• 32,490 points
9,284 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,490 points
601 views
0 votes
1 answer

Using Treemap as a filter

What you want is possible using the ...READ MORE

answered Dec 17, 2018 in Power BI by Shubham
• 13,450 points
1,503 views
0 votes
1 answer

Left Outer Join using DAX in PowerBI.

You can simply write a few measures ...READ MORE

answered Sep 24 in Power BI by Gitika
• 41,720 points
36 views
0 votes
1 answer

How to get month name from month number in Power BI?

You can use: MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE

answered Sep 24 in Power BI by Alisha
28 views
0 votes
1 answer

Power Query Web request results in “CR must be followed by LF” Error

What I think is, it might look ...READ MORE

answered Oct 29, 2018 in Power BI by Shubham
• 13,450 points
507 views
0 votes
1 answer

Select Columns from table instead of removing afterwards in Power Query

Try this. let db = Sql.Databases("sqlserver.database.url"){[Name="DatabaseName"]}[Data], Sales_vDimCustomer = ...READ MORE

answered Oct 31, 2018 in Power BI by Shubham
• 13,450 points
1,106 views