#powerquery

Hello: I have found this query, which works perfectly at giving me the ability to look at all of the queries currently built. let Source = #sections, Section1 = Source[Section1], convertTable = Record.ToTable(Section1) in convertTable Does anyone know how to update the...

I am new to Power Query and I have been running into memory issues when using large time series data sets. An I am wondering if it is a usage issue on my end based on me not fully understanding how Power Query handles large data sets. I was hoping someone could clarify a few items for me. What...

Hi I want to know how to do matrix math in Power Query. I have a query (Query1) that produced a table (Connection only) and It is time series data in Column 1 with a large number of columns representing data specific to each column header. The column headers for column 2 onward all have unique...

Hello, I am using Get & Transform in a VBA routine to get the contents of a webpage that I want to later parse. The content is bills from our state legislature and how the legislators voted. Each Bill has its own page, so I want to build the string according to the bill number and use the...

I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code.... i was Create MODULE and put this VBA code , So Amazing Trick to ,make Print TO PDF with Duplex (Both-side),,,,, Kindly Provide set VBA code For both page Margin...

How to get the data based only from the date that the user input in power query? e.g. DATE RECEIVED 9/9/2022 9/10/2022 9/11/2022 9/14/2022 9/15/2022 Date that the user input Start Date : 9/10/2022 End Date: 9/15/2022

I have a Table With URL's that I need power query to load table form each webpage and combine it as one The problem is , my query takes long to load the data, I tried Table.buffer but it doesn't seem to speed it up any better, How do I Edit My Code to be efficient? 1st Table Named "Engine"...

Hi All, I have a table below for which I need to change the background color for the values using DAX measure in conditional formatting. I have also added the output image with the conditions that I want to apply in the measure. I have already tried the measures that are already mentioned in the...

Hello, I searched a lot but didn't find an answer to this. I have loaded in power query 4 columns like this (after some tweaking) REP 1 REP 2 REP 3 REP 4 null Customer1 null null Customer2 null null null Customer3 null null null null null Customer4 null null null null...

Hi, I'm getting this error in Power Query and it looks like it's in the GroupedRows step. Any help is appreciated! let Source = Table.Combine({#"① S01_RR_Revenue", #"② S02_GDSF_CYPeriod", #"③ S03_GDSF_PYRemovals"}), #"Filtered Rows" = Table.SelectRows(Source, each ([FIRM] = "1360") and...

This Formula use , Missing Date find perfect , but we need Find "Bill Number " , Because my file Large Amount of Bill Numbers ( May be 3000 Bill Number ) =SMALL(IF(ISERROR(MATCH($E$2+ROW(OFFSET($B$2,0,0,$E$3-$E$2+1))-2,$B$3:$B$7,0)),$E$2+ROW(OFFSET($B$2,0,0,$E$3-$E$2+1))-2),ROW(A1)) ( This...

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...

How To make Hyperlink >Workbook File > Sheet 1 (Particular sheet link) # i try excel file create other excel file to particular sheet hyperlink making...... Pleased help me

Currently, I am using the following steps in Power Query to get a list of columns for List.Sum function in a later step. There is the Table format Date Store Product Discount.A Discount.A% Discount.B...

Hi, I have some formula's that I am trying to replace using Power Query.... not sure what the best way to explain this is but I will explain the scenario in excel first. I need to look at column 1 and return the value specified in the lookup table, but if the number doesn't exist in column 1...

Power Query makes Excel crash - can't access Data Model Hi, I think this may be Sharepoint related - my document was not initially synced to Sharepoint and worked fine - but not since it has been Synced. Issue: Power Query set up to pull and transform data from External Excel file (in same...

Please HELP I am able to count total number of candidates from CANDIDATES TABLE (attached) columns from date applied, Recruiter interview, manager interview, Offer, Start. However i want to see see custom activity for last # days on a particular reqID I want to see custom custom count for last...

I need to 1. Find the MAX of students on 2 variables. (course and country), 4 countries x 3 courses, so there are 12 MAX answers. 2. Filter the data to only include dates in say 2015 using a "timeline" slicer (not all) 3. SUM the results of step 1 filtered by step 2, this time...

Hi guys, I have a report that I regularly refresh with a new table of data. Right now the values in my report are pulling from the table using sumproduct formulas since the values have to meet a wide variety of criteria and I don't want to go through all the necessary redefine/refresh steps...