No announcements

Calculating the Inverse of Matrix in Power Query/Query Editor?

I'm trying to determine if there is a way to calculate the inverse of a square matrix in Power Query?
| 1 Replies | 656 Views | Created by wallace1313 - Friday, August 24, 2018 3:19 PM | Last reply by Ehren - MSFT - Thursday, September 13, 2018 4:57 PM

Power query editor filtering

my dataset is 250,000,000 rows, too big for excel. in power query editor I filter column A and reduce the rows to ~1000, when I then filter column B it analyses all of the ...
| 2 Replies | 436 Views | Created by Stevent88 - Tuesday, June 23, 2020 1:20 PM | Last reply by Ehren - MSFT - Thursday, July 9, 2020 5:41 PM

Create calculated columns in power query

Is it possible to create calculated columns in power query? For example, I have sales \$'s and sales units, and I would like to create an average sale price column ...
| 1 Replies | 753 Views | Created by Albo44 - Monday, April 17, 2017 8:46 PM | Last reply by MarcelBeug - Tuesday, April 18, 2017 3:37 AM

Power Query Recursive Calculation

Isn't that the intent of a recursive call? Do you have a better suggestion on how to simulate the excel formulas shown? In the example, cell I11 refers to cell I10, etc. and power ...
| 10 Replies | 576 Views | Created by MyronKnowsNothing - Wednesday, February 5, 2020 8:27 PM | Last reply by Imke Feldmann - Saturday, March 7, 2020 8:21 AM

Annoying bug in Excel Power Query Editor when selecting a query

I am experiencing a very strange but annoying bug in Excel Power Query Editor. When I select a Query in the Querylist and I move my mouse the query I had ...
| 2 Replies | 373 Views | Created by martinitram - Thursday, October 17, 2019 11:53 AM | Last reply by - Friday, November 1, 2019 11:57 AM

How to combine multiple queries in query editor and add calculated columns?

Hello, I have three queries that I want to combine in Query Editor so when I return data to my excelsheet, the data will be returned all at once. I have ...
| 2 Replies | 788 Views | Created by SPEHE - Tuesday, June 2, 2015 8:35 AM | Last reply by SPEHE - Tuesday, June 2, 2015 9:18 AM

Query Editor or Query designer

How does add tables to a Query editor from different databases? What I actually want is to add tables from diffrent databases
| 2 Replies | 4789 Views | Created by Ashru - Friday, April 25, 2008 2:18 PM | Last reply by Jonathan Kehayias - Friday, April 25, 2008 4:15 PM

Inverse a MxN matrix with SQL

, it is highly asymmetrical. A column is supposed to model a unique attribute, and the SQL language is defined serve this needs. A matrix inversion like you describe is ...
| 4 Replies | 8787 Views | Created by CosmeJ - Monday, April 25, 2011 6:23 PM | Last reply by --CELKO-- - Monday, April 25, 2011 7:48 PM

and D. For D I would like to create a new table in power query editor where it lists the dates between start and end. So far each formula I found online ...
| 7 Replies | 840 Views | Created by Multiculturefruit - Wednesday, July 17, 2019 7:06 AM | Last reply by Emi Zhang - Wednesday, July 24, 2019 9:35 AM

Query Editor

Hi, in the ribbon look under the Data tab. Then check the External Data group. check from other sources that's where you can find the query ...
| 2 Replies | 751 Views | Created by Jessicasdd - Thursday, December 18, 2014 3:15 PM | Last reply by Jessicasdd - Thursday, December 18, 2014 9:09 PM

Can the "Percentile" be calculated in Power Query?

Power Query doesn't have a percentile function. You can load the data to the Data Model and then use PowerPivot to calculate percentiles. Read ...
| 8 Replies | 11175 Views | Created by Qilong L - Monday, January 5, 2015 1:49 AM | Last reply by pieterjans - Tuesday, December 4, 2018 2:29 PM

Query Editor

Hi there. Please see the Applied Steps pane. Ehren
| 1 Replies | 1552 Views | Created by SK2017 - Tuesday, September 5, 2017 7:23 PM | Last reply by Ehren - MSFT - Wednesday, September 6, 2017 7:27 PM

matrix query

I have the need to create queries that contain dynamic columns as in a matrix for example. a town cash report. columns are ...
| 2 Replies | 6792 Views | Created by JerryCic - Tuesday, November 28, 2006 7:09 PM | Last reply by JerryCic - Tuesday, November 28, 2006 8:44 PM

Power Query Previous day calculation

Hi all, I want to ask if there is a way to create a previous day formula in power query. I am using Power BI for it and I am kind of new in the ...
| 2 Replies | 2365 Views | Created by Jmenas - Monday, May 15, 2017 9:08 AM | Last reply by Colin Banfield - Tuesday, May 16, 2017 1:14 PM

I am looking to replace the middle number of this hyperlink with the equation that is in the text.combine function. Here is what I got so far, I am getting a syntax error for the text.combine ...
| 3 Replies | 372 Views | Created by brandsand - Tuesday, June 9, 2020 3:14 AM | Last reply by brandsand - Wednesday, June 10, 2020 2:50 AM

Loosing calculated columns and measures in PowerPivot/Power Query

I import from an Excel file via Power Query into the data model. Then adding calculated columns and measures in PowerPivot. Next time I open the workbook, the connection is ...
| 1 Replies | 1023 Views | Created by Jan-Eric Ramberg - Saturday, October 17, 2015 8:30 AM | Last reply by ckekiass2012 - Monday, October 26, 2015 1:32 AM

Power Query Expects Int when Query Editor doesn't

Hello, I am introducing a Power Query (over Excel Office 365) to a new organization in order to retrieve data from an InterSystems Cache DB (not SQL-Server or ...
| 4 Replies | 428 Views | Created by Barak _ Bester - Tuesday, January 31, 2017 8:29 AM | Last reply by Curt Hagenlocher - Thursday, February 2, 2017 2:38 PM

Numbers in a table are rounded in Power Query Editor

changing the type to currency just out of curiousity, but the values remain as rounded integers.  How do I get the decimal numbers to show in power ...
| 3 Replies | 746 Views | Created by DanielM31013 - Thursday, April 18, 2019 3:36 PM | Last reply by Ehren - MSFT - Monday, April 22, 2019 6:06 PM