No announcements

### Runnig total in power Query .

In here is my version (inspired from the same source:  http://www.excelguru.ca/blog/2015/03/31/create
| 16 Replies | 7972 Views | Created by Prabhakaran Sreenivasan - Tuesday, June 9, 2015 5:29 AM | Last reply by Imke Feldmann - Wednesday, January 2, 2019 8:29 AM

### How do i create a Stock on Hand Trend Line?

| 1 Replies | 521 Views | Created by Nuj_ - Wednesday, June 24, 2015 5:44 AM | Last reply by Imke Feldmann - Wednesday, June 24, 2015 6:21 AM

### Associate Each Customer Sale With A Supplier Order ID (First In First Out Rule)

-6f42fd3973fd/runnig-total-in-power-query-?forum=powerquery When I started thinking about this exercise, I was under the impression that I need ...
| 2 Replies | 685 Views | Created by Bond. James Bond - Friday, January 22, 2016 7:12 PM | Last reply by Bond. James Bond - Wednesday, January 27, 2016 1:48 AM

### EXCEL PIVOT TABEL: CAN NOT ADD RUNNIG TOTAL

: type (= text) and values: value (= values)   Now I tried to add a runnig total to the pivot table
| 4 Replies | 6789 Views | Created by vanilla1983 - Tuesday, December 2, 2008 8:31 AM | Last reply by vanilla1983 - Tuesday, December 2, 2008 3:09 PM

### Power query running total with multipe sum values

Hey Colin, Thanks much for your solution. Unfortunately the results are not as expected. All YTD values come up as null in the power query. Perhaps a ...
| 4 Replies | 1113 Views | Created by IT is not a tumor - Thursday, February 8, 2018 1:09 AM | Last reply by IT is not a tumor - Thursday, February 8, 2018 11:11 PM

### Incorrect total in Power Bi

Hi, I have a decimal column in Power Bi with positive and negative values, when I put that column (by itself) to a graph or a table I get a total of -2 billion, ...
| 2 Replies | 515 Views | Created by RachelM.A - Sunday, February 18, 2018 6:09 AM | Last reply by RachelM.A - Sunday, February 18, 2018 6:33 AM

### How to calculate conditional running total in power query (Excel 2016)?

Is it possible to calculate conditional based running total in power query? I need to add numbers(cumulative sum) based on the group. Please see the image attached. ...
| 4 Replies | 4655 Views | Created by Jithin.RG - Friday, March 23, 2018 4:16 AM | Last reply by Jithin.RG - Monday, March 26, 2018 9:06 AM

### cant runnig

run script User's domain is mydomian. Total estimated token size is 1304. For access to DCs and delegatable resources the ...
| 14 Replies | 604 Views | Created by hamed_forum - Wednesday, January 30, 2019 12:31 PM | Last reply by hamed_forum - Sunday, February 3, 2019 5:30 AM

### Power Query and Power View

Yes, currently Power Query does not support SSAS Tabular as a data source.
| 2 Replies | 1231 Views | Created by garyandadriel - Thursday, August 21, 2014 8:22 PM | Last reply by Ehren - MSFT - Thursday, October 16, 2014 5:53 PM

### Totals in Power BI

Excel 365 Pro Plus with PowerPivot and Power Query (aka Get & Transform) Instead of DAX-SUMMARIZE() you might try PowerQuery-GROUP(). PQ has ...
| 1 Replies | 837 Views | Created by Dan_dosReis - Wednesday, December 12, 2018 2:17 PM | Last reply by Herbert Seidenberg - Saturday, December 15, 2018 4:43 AM

### Power Q&A - Sorting by total

Hi, I've got a view like below on my Power Q&A, which is produced by asking following question: show day and <fieldname> sorted by ...
| 3 Replies | 3286 Views | Created by Dawid-SC - Monday, December 1, 2014 11:35 AM | Last reply by Ed Price - MSFT - Sunday, July 10, 2016 6:30 AM

### Power Query

Hi, i have Microsoft Office Professional Plus 2010 (64 bit). I am trying to install Power Query and i get a message "you need to have excel 2013 or excel 2010 ...
| 4 Replies | 424 Views | Created by komhs74 - Friday, December 21, 2018 11:28 PM | Last reply by komhs74 - Saturday, December 22, 2018 1:11 AM

### Total query

What is the query to also give the something_cntal per foobar_name? Something like this: Total    foobar_name ...
| 5 Replies | 354 Views | Created by aujong - Wednesday, July 27, 2016 4:39 PM | Last reply by --CELKO-- - Wednesday, July 27, 2016 11:32 PM

### RUNNIG A JOB???

using an OLE DB source to retrieve some data from the db... netx step i use this data conversion task because some of  the results of the query aren`t supported by mi ...
| 18 Replies | 7131 Views | Created by ruk_walled - Thursday, May 4, 2006 9:10 PM | Last reply by ruk_walled - Friday, March 30, 2007 5:13 PM

### 80/20 rule

ABC Approach in Power Query as well: In my last comment there:
| 11 Replies | 1624 Views | Created by yan_elf - Friday, August 21, 2015 9:46 PM | Last reply by yan_elf - Friday, July 29, 2016 9:35 PM

### Power Pivot & Power Query

| 3 Replies | 1133 Views | Created by SJL6357 - Tuesday, December 2, 2014 12:25 PM | Last reply by George123345 - Thursday, December 4, 2014 1:19 AM

### Lost Totals in Access Queries

Are you consuming this Access data in Power Query, or are you referring only to Access queries? Ehren
| 1 Replies | 204 Views | Created by cFolds - Tuesday, April 11, 2017 1:29 PM | Last reply by Ehren - MSFT - Wednesday, April 12, 2017 5:17 PM

### Power Query : How to insert custom column based on total hours

Hi Rajender, From what I can tell, your desired output should be doable in Power Query. However, I'm still having trouble understanding exactly where you're ...
| 6 Replies | 1049 Views | Created by AskQuery1984 - Friday, August 19, 2016 4:15 PM | Last reply by Ehren - MSFT - Friday, September 2, 2016 10:08 PM