power query

  1. D

    multiple share prices

    Please help for the code I wrote to download Multiple Stock Prices at once. Ringing for Single Share. However, it is not working for many shares. One Stock working: One_Stock.xlsx dosyasını indir - download Multiple Stock Not working...
  2. D

    SUMX iterate over smaller table using VALUES

    Hello, just to note I meant to put VALUES not RELATED in the title, but posted and edit won't let me change it. (edit: changed for you :)) Just a question regarding what's actually happening,; I have a formula ; Over...
  3. S

    Need help on dynamic date filter in Power Query

    Hello Everyone, I need help to filter dates in power query based on cell value mentioned in excel. Following is my sample sales dataset Order Date Region Rep Item Units Unit Cost Total 06-Jan-21 East Jones Pencil 95 1.99 189.05 23-Jan-21 Central Kivell Binder 50 19.99 999.50...
  4. D

    Downloading stock list in one go with loop.

    Hello, I want to download the Stock list in one go with a loop when I refresh the page. I want it to download every stock in the stock list to the "combine sheet". ----Combine sheet 1st share "C3", 2. Share "C163" ... I want to download as in the example. ----In the same way, I should...
  5. D

    Downloading stock list in one go with loop.

    Hello, I want to download the Stock list in one go with a loop when I refresh the page. I want it to download every stock in the stock list to the "combine sheet". ----Combine sheet 1st share "C3", 2. Share "C163" ... I want to download as in the example. ----In the same way, I should...
  6. wsnyder

    Date EndOfWeek Returns Saturday Instead of Sunday

    Hi all, Using Excel M365 Beta. I entered 1/1/2022 into a cell and import into PQ I added a custom column and entered the formula: Date.EndOfWeek(#date(Date.Year([Column1]), Date.Month([Column1]), Date.Day([Column1])),Day.Sunday) But it is returning 1/1/2022. But I expect 1/2/2022. 1/1/2022...
  7. P

    Power Query won't concatenate some fields

    Hi, I have several tables imported from a Ms access db. I have edited some of the tables in power query. When I append all these separate tables into 1 and load it to a table the tables that I added custom columns to won't concatenate thier data with the rest. It should all be on one row...
  8. M

    Power Query - Change SQL Datasource Parameter with Multiple Values

    Hi All, I've been stuck with this problem for over week - watched and tried numerous methods to no avail. Hoping anyone can help me with this. I connected a dataset from Microsoft SQL Server to an excel spreadsheet through Power Query. The problem is, the dataset is so large hence I have to...
  9. D

    Load Power bi table into power query

    Hi, I've created a date table in power bi, but need to make some alterations in power query, but when I select 'transform' to bring up the power query editor, only the source table for the date table is visible. what am I doing wrong. RD
  10. T

    Change folder location from desktop to drive - Power query.

    Hi, hope someone can help. I got a folder with excel-files on my desktop, that is linked to a power query. I like to change the data source (location) of this folder to my drive. (name & content are the same) - copy/paste from the desktop. I have tried to change "Data Source Setting" and...
  11. B

    Power Query - Transforming Messy Data

    Hi. This is my first post. I have MANY spreadsheets that have been formatted for print and I am working to combine and automate these files for easy retrieval and EDA. The files are formatted like this: I have a process to get to the data in the format that I want, but it is clunky and...
  12. S

    Power Query - API Call from Web

    Hi, I am trying to get the minimum prices from winesearcher with an API call in power query. Here is the code: Xml.Tables(Web.Contents( "https://api.wine-searcher.com/x?api_key=???????? &winename=[Weingut] [Weinname] &vintage=[Jahrgang] &location=Europe &currencycode=EUR &bottle_size=b...
  13. szita2000

    Query another excel file that might be open at refresh

    Hi All. I have two excel files, one supposed to pull data out of the other one, but the source file might be open. There was a way in Power Query (if I remember correctly) that if I only created a connection and added the data to the Data Model the the query would only open the source file in...
  14. J

    Refresh All and then Message stating Complete

    Hi Again! What is the best way to use the ActiveWorkbook.RefreshAll VBA and then provide a Message Box stating that the RefreshAll is complete? I have had my queries refresh in a particular order, only because I am in need of a message of its completion, there is really no other reason for me...
  15. J

    Power Query - csv OR table in xlsm

    General Question. What is the better option to be using as a data source, a csv file OR a table in an xlsm file? Is there any refresh speed difference by using one over the other? Thank you in advance!
  16. L

    Merge two different organization keys, from different data warehouse

    Hallo. Assignment: I have to build a report, in Excel, that shows the sum of measures, when the user drills up and down our organization hierarchy. Challenge: Data comes from two different data warehouse, that uses different organization keys, for the same department. Department names is...
  17. A

    Programmatically point Power Query to a different SharePoint list

    I have an Excel workbook that pulls data from several SharePoint lists on a Microsoft 365 tenant for ABC Company via Power Query. I have the exact same SharePoint lists exist at XYZ Company's tenant. I would like to have a button that programmatically switches the Power Query source from one...
  18. J

    Power Query Refresh - How much longer

    I don't know if this is something that is available, but is there a way to show a status of refresh whether it be a countdown timer or a percentage complete? And I'm talking more of a visual that pops up, rather than keeping an eye on the Queries and Connections pane. It's not a necessity, but...
  19. V

    I need to display Average of a calculated column on basis of month wise data

    Hi Team, So, I have a power Bi task at hand where I have created a dashboard . Issue is I need to display average of a calculated column by month for eg; I have a column with name CSM readiness CSM readiness = csm1 + csm 2...
  20. P

    VBA and PowerQuery: Get value from query without creating table on worksheet

    Hi all, I have an Excel file with an underlying pretty complicated PowerQuery query. On the Excel sheet, I have a table from a query, which displays only the needed information, without any redundancy (meaning, that you cannot calculate one column from another). I want to have a button, which...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top