power query

I am working with a price list and would like to select pivot table fields (column headers) based on the price level (PL) selected which is also a column headers. The price level is indicated by Z0 and Z1. This particular column header can be used or not as part of the solution because there is...

There is an Excel Add-in that makes retrieving Economic Data from the Federal Reserve (simply called FRED Data) easy. However, there are inherent problems it presents. You put the CODE of the data series you want in row 1, and optionally add Data Manipulations (such as retrieving the change from...

Greetings Everyone, As it is my first post I would like to thank you for opportunity to join this community. My name is Piotr and recently I have been asked to download data from transparency platform using API and Power Query. I have never seen or used Power Query or API therefore I kindly...

Hello, Pivot coloumn on Power Query excel, but i have problem eror with description like this "There were too many elements in the enumeration to complete the operation". How to resolve errors on pivot coloumn? Thanks

Hello everyone I can easily separate quarterly balance sheets by quarter in excel. Is it possible to do this in a power query? Please help if possible. https://dosya.co/vd1c2pxgezhz/_____Finansal_Tablolar.xlsm.html

Hello, I have a table with three columns. Date, Location, and Count. What I would like to do is keep the Date column as it is, make the Location column into three separate columns (Garage, Preferred, and Outdoor) and then populate the rows with the counts that correspond to the date by...

Hi there. I've been using PowerQuery to collapse a flat file into combined, multi-value cells with delimiters. The inconsistent nature of the raw data results in repeating delimiters / spaces, like so: ; ; Smith, Judy; Carson, Kevin; ; Levy, Kevin; Bloom, Judy; ; ; ; Nicholas; ; ; I'd...

Hi there. Long-time Excel user and dabbler in VBA and Power Query. I've got a variation on a problem I posted a few years ago in this thread. There, folks helped me use PowerQuery to collapse data, combining multiple rows into single, multi-value cells while removing duplicates. The wrinkle...

I want to connect a file from OneDrive as a data source in Power Query. I understand that the best way to do this, is to copy the OneDrive file path and then paste the link into New Source>Other Sources>Web (see reference pictures below). However, I do not see the same "Copy File Path" icon...

Hi all, I have multiple tables in the same workbook that are formatted with the column headers in one column and the corresponding data to the right (formatted this way for easier visibility of the user). See Tables 1 and 2 for examples. They all have the same naming convention beginning with...

Hi everyone. I have found some information on what i am trying to achieve buy i am failing at making it work. I have a sheet " Links by City " in which i have city names and beside them the link to the forecast website i use that is specific for that city. At the moment only have 5 links and...

What is 'MoreQuery for Mac' add-in? Starting in early 2023, we finally have a more powerful Power Query on Mac. However, there are some missing Get Data options which are essential for almost everyday use. I personally don’t understand why the development team didn’t include these essential...

Hello, I have some request in my excel sheet that are loaded every day by a macro. The problem is the data that are recovered are not the same as the data that are on the preview of the power query request. The difference is always on the hour. Do you have an idea why ? Thanks

Hello all, I have a sheet with several 'Boxes' of information side by side. Each 'Box' corresponds to a certain label. This particular sheet has 23 of these boxes I want to use power query or some other means to get those boxes stacked vertically instead of horizontally. Using Transpose in...

Hi! I am struggling to find a suitable solution for this problem, and hoping you guys can help me. I have 3 different worksheets containing training matrces for installations; Each tab belongs to an installation; The columns and structure are the same for all of them, and the difference...

Hi PQ Gurus, I have a tall order, which I know I would NEVER be able to figure out myself, and am hoping one of you experts could assist. I know the requirements are pretty extensive, but would appreciate ANY help in trying to figure this out. I have a large data set (small sample below), and...

In Power Query I'm trying to filter out and total rows from a data set. Total rows are designated as "Total ..." in [Column1]. So I used the drop down "Text Filter > Does Not Begin With..." which places a "not Text.StartsWith([Column1], "Total") in the code. The problem is this not only...

Hi Guys, Pretty new to excel so hoping there's a simple answer to this that I'm not aware of. I work in marketing insight and part of my role is selecting the best customers to send each of our direct mail campaigns to, and I want to create a workbook in where I can walk through our monthly...

I split a column by a space delimiter, after I have unpivoted the index column and try to group i get the following error: "DataFormat.Error: We couldn't convert to Number. Details: a" How do i fix this?

hello everyone finding and editing from a forum previously does not open this query anymore. I couldn't understand if the reason is from yahoo or in the query. Also, the following query is very complex, is it possible to make a simpler query? ___Dnz.xlsm dosyasını indir - download