#powerquery

Might just be a dream of mine, but thought I would ask. I know PQ sets its own path for refreshing everything, does it come with a specific Sort that it sticks with OR does it just plunk it out however it is least resistant to its own processing? Is there a way in Editor to set a Sort and...

Good day, In Power Query, I need to go from this: Serial Number Date/Time Data Pont 1 Data Point 2 0001 08/14/2024 10:00 DP1A DP2A 0001 08/14/2024 10:10 DP1B DP2B 0001 08/14/2024 10:20 DP1C DP2C 0001 08/14/2024 10:30 DP1D DP2D 0002 08/14/2024 10:00 DP1A DP2A &c. to this...

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...