query

I have a table TTimeRecords with records including DateofJob and HoursofWork. DateofJob | HoursOfWork 1/1/19 | 6.0 1/2/19 | 8.0 1/2/19 | 6.0 1/3/19 | 7.0 1/3/19 | 8.0 I then wanted to create a query in which hours were summarized for 2019 on a weekly basis, with...

I have a table that has serial numbers with dates that show when a job was entered, the date it was closed and the date it was installed. The Date of the installation is on the incorrect line and I would like to have it put onto the correct line. How can I do this in Access without going thru...

Hello everybody, I'm trying to download financial data from yahoo finance: specifically I have all the tickers of the shares of the Italian market (circa 450 stocks) in an Excel file and I would like to extract some tables from the "key-statistics" section. I'm not very skilled with VBA and...

Hi, I am beginning in power Query in Excel. I have a general issue is the speed of refresh. I have something very basic code like : Source1 = Excel.CurrentWorkbook(){[Name="tblprofit"]}[Content], #"Filtered Rows1" = Table.SelectRows(Source1, each ([Sales organisation] <> null) and...

Hi, In Query, is there any way to get the information that in the table sourced which columns have excel formulas, which columns have values? Thanks!

Hi, Something strange when using Queries: I found a huge speed difference between these 2 situations : Situation1: - I make a first query "query1" and I do not load the result on a worksheet1 - I make a second query "query2" which call the "query1" by basically Source1 = query1 and do some...

Hi, I am starting to use Power Query. After query table is done, I load it to a specific sheet to get the results, then I can use again this table for further calculations. My question is: do I mandatory need to load the query table in a sheet to get the data for further calculation in excel...

https://imgur.com/a/2bFUSl2 At the switch over to 2020 it just shows as an error using the following #"Changed Type" =Table.TransformColumnTypes(Data0,{{"Column1", type date}, Is there an way to handle this?

Recently I have had both relatively small power queries (180 rows, 10 lines of M code) and larger (approx. 6000 rows, 25 lines of M code) stall at the load stage. It happened first with the larger query and I thought it had to do with the size of the query. But it has now happened with smaller...

I noticed something odd today and I don't know if this is new or if I just never encountered this before. I have 3 files in a folder and imported from the folder into Power Query. 2 of the files have 2 columns, 1 file has 3 columns. Power Query imported just the first 2 columns from each...

Excel 2016 64-bit - Suddenly my calendar file that loaded just fine is throwing errors that there are duplicate dates, so it can't join to the other DAX tables. The query appears just fine in PQ but blows up when I try to load to the Excel data model. These lines at the end don't make a...

Hi, I have posted a generic query regarding ‘PtrSafekeyword’ few days ago. However not able to find my post hence posting as new thread. I have below line of code in my macro and am required to update it with ‘PtrSafe keyword’ Private Declare Function GetPrivateProfileStringLib "kernel32"...

I have an Excel file that uses Power Query to get data from two Access tables. The query is executed via the following VBA code in the Workbook_Open codeActiveWorkbook.Connections("Query - SourceFileName").Refresh ActiveWorkbook.Connections("Query - GoodsOut").Refresh The SourceFileName query...

Hi, I have a power query qryTotalSales that simply has SalesAgentID and SalesVolume as an aggregate SalesAgentID SalesVolume 1 27 2 4 3 72 4 11 In another power query qryThreshold I have restricted...

Hi, I have a Excelfile with a power query model in it. It works fine on one computer, but when I run it in on another computer there are errors. I use excel 2016 on both computers but the one with errors crashed a couple of weeks ago and got office reinstalled just the other day. The error...

Hi - I have a problem with power query not updating all data from my source file. My query was created from file / from folder, and I currently only have a single file in that folder at the minute. I have imported that data into power query with no issues currently, however if I change some...

Hello, I'm trying to do a simple web query for a couple of sites, but however their tables are coded, it only queries the first page of the table rather than all results. When clicking to the next page of the table (or selecting to view all rows), the page URL doesn't change, which eliminates a...

I am sure this can be done, but I am not able to find anything specifically addressing it. Is there a way to create a DateDiff parameter in a query, where is it calculating the days, between current date and a date field within the table the query is built from?

I'm trying to create a macro that does the following: On theButton was clicked set theButton style =msoShapeStylePreset12 Run the query Query refresh completes set theButton style = msoShapeStylePreset14 end But, the button doesn't change until after the query has refreshed. I eve...

So I have a certain table-list, which will have data populated or deleted sometimes. I also have queried raw data. I want it to add 1 more column when 1 more record gets added to table-list and delete 1 column if 1 record from table-list gets deleted (it doesn't have to be certain place where...