powerquery

Hi all, I am currently downloading a bunch of sheets that look like this: I would like to make an overview in my sheet called "List", where the data from "Sheet1" is automatically pulled in. However, I would like to do this without making any changes to the downloaded sheet, including not...

Hi, I have a question to all M experts - I would to make, in one single step, multiple custom columns like this Statement : = Table.AddColumn(#"Reordered Columns", "XXXXX", each if [XXXXXXt] = "XXXX" or "XXXX" then Value.Subtract(each [XXXX] - [XXXXXX.XXX]) else null) Do you know a way ...

Hi team, Can you please help me find a solution to the below issue? I tried Vlookup, but it is really time-consuming. I have two sheets. One with the contact details and one with the product details. I want them to map it based on the account data. Sheet 1: Sheet 2 Result required ...

Hello, I want to have a column that will show time difference between Time(i) and Time(i+1) for example: FIRST ROW 08:46:30 - 08:46:23 = 00:00:07 SECOND ROW 08:46:31 - 08:46:30 = 00:00:01 etc. Any ideas how can I achieve this in Power Query?

HI There I have a power pivot (also in powerquery) table ProcessData that includes 3 columns: UniqueItemRef; Status; Update (=datetimestamp) If an item has passed through several statuses it will have several rows for those statuses (same UniqueItemRef and Status on each row) Also, if...

First off I apologize for the lack of detail, this is for work so I cant give exact info on variables etc. Also I am new to PowerQuery. I have established my ODBC connection (=Odbc.Query("dsn=private", "Select#(lf)variable1, ...") so: (Select x, y From z Where x in ('')) and I would like to...

Hi, I’ve got a folder that has got multiple excel files (50+) with each file containing a weekly summary. As it is a weekly summary, each week, a new excel file is added to the folder. Currently, I’ve got a “master” excel file that is linked to that folder using PowerQuery and imports all the...

Hi everyone, I hope you are well. I have a spreadsheet that evolves every week. I used Power Query and imported the workbooks produced the past weeks, basically copying the query and simply modifying the source. Is there a way to remove alla common data (what remains unchanged basically) and...

Hi! I have 2 columns. Column A - Amount ($) all in absolute values Column B - Status (either named as Accepted / Cancelled) In excel, we could input a formula =IF(B1="Cancelled",-A1,A1) Can this be done in Powerquery? If so, how would I do this? Thanks!

Hi All, I am currently using code to split data from a single column (copied from pdf) to separate columns for easy reading. There are over 5000 entries within the spreadsheet and it is slow to complete the macro. Does anyone have any tips for speeding this up or using powerquery instead? I've...

Hello, Office 365 - Power Query Built In I am trying to use the code in the first reply given here so that I can add some events once the power query on "PQ_Cons_Depr_LOCAL" tab refreshes. However, I can't seem to get it to trigger. Any help appreciated.

Hi all, I am a novice and learning as i go along and I was wondering if i could tap into your expertise. I have a folder with about 100 of these files to impot which i am trying to merge into 1 master file. Each workbook has a similar format in terms of structure. However, the store number...

Does anyone know how I can transform my data from TableA to TableB. Either using macro or using Powerquery to perform the task? Requirement: If there is a customer in CustomerName B col, duplicate the row and move the customer to CustomerName A col.

Dear All, Especially the ones more familiar with M code, databases and data analysis. I admit that PowerQuery and M code seem to be quite a versatile tool, but I am puzzled by its low performance. So I wonder - is it me doing something wrong or it's just the way it is. Is there anything I can do...

Hello All, I currently manage 10 Locations and for each location I have 6 different CSV files that contain anything from sales to employee ect... I have cleaned up the data using power query with conditional formatting as not every column is used and some calculations are being done along with...

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????

Hi all, I've made massive headway in what I'm trying to set up in finding Power Query. What I'm trying to do is create a backend Excel sheet that compiles the information from multiple frontend workbooks in a folder. Easy-peasy, however, I cannot refresh the backend while any of the source files...

Hello, I am trying to attach several columns in one table to one column in another. Here on the "Accessory" table, we can have up to 3 devices, in the three columns. Device Type Device Type2 Device Type3 IPHONE 6S+ IPHONE 7+ IPHONE 8+ IPHONE 12 IPHONE 12PRO IPHONE 12 IPHONE 12PRO...

Hello, I am using Power Query to pull multiple data sets into a single workbook. I have a table within that workbook that contains a dropdown. What is selected in that dropdown determines how the data pulled in by Power Query gets filtered. See attached for further explanation. It works...