power query

Greetings, Ok so I'm trying to go from A to B....Need to split the data in the email address column, THEN, create additional line item.. Not sure if a formula would work, might have to try VBA...Please Help A Profile ID Request Type Change Type Email Address 1 Notification Yellow...

Hi, I'm trying to either with POWER QUERY or DAX find a way to go through my list of sold items by invoice number and look for items returned that were never sold to the customer. The item could be sold to another customer which is fine. But I'm looking for returns that are not valid as the...

Hi, I'm looking to find items with returns (-1) units that were never purchased. Below is my power query that pulls all sales and returns. But I want to create a column that says the item returned (-1) was never purchased. Therefore does not exists in the table as a value of greater than 0...

Hi I have a power query below that list all my sales. I looking to add a column that identifies any sales that have a returned item. Then I can see every sales with returns. let Source = Sql.Database("doff", "DB0000_171202195501"), dbo_tblSale = Source{[Schema="dbo",Item="tblSale"]}[Data]...

Hi All. I am trying to create a spreadsheet which takes employee swipe times onto a site and gives how many hours they have worked. The format I have gotten it to gives me their name, date and entry on one row and then name date and exit on the second. But how can I combine these into a...

Hi I have the following table that contains everything in one cell. I want to extract the last date entered in that cell and size in the formate of (00/00"). That two columns should be added to the original table similar to pic below.

Hi I have the following code to convert sheet range to number in power query, The range named "Tests" would accept any thing except number. I know there is minor change I have to do, but I couldn't figure it out. let Source = Excel.CurrentWorkbook(){[Name= "Tests"]}[Content], MyList=...

Hi, I have 15 Excel reports sourced from SharePoint. The Source.Name column captures the report name which has the date mentioned. Please advise how I can create a Report Date column that only captures the date from the Source.Name column so that I can hide the Source Name column before loading...

Hello; I am cross-posting this question from SO. I'm using an API (for a project management database) that returns a result in the following form (in JSON format): {'Content': { 'Projects': ['project1', 'project2', 'project3', 'project4'], 'InvoiceGroups': ['group1'...

Dear All, I need your help in regards to the problem I am facing in Power Query in Excel. I have a folder where every month I save monthly Transactions Report. Then I combine them using Power Query to get YTD Report. All the columns names are same and it was all going well. Today I saved the...

I have a workbook with sheets for each financial year from 2010 onwards. All column headers are the same across all sheets. I need to be able to combine all the sheets into one sheet *BUT* I need this combined sheet to change with the others if rows are added/deleted in any of the other sheets...

Hello Excel Gurus! I have a challenge which I cant' quite tackle using Power Query but I'm sure there's a genius out there who can! My problem is as follows: 1. I have a "Colors" column which contains a list of concatenated colors 2. I want to split them by column and then dynamically rename...

Hi, I've cells on two rows which are merged, however, some cells are not merged and have different values/data. E.g. I want to bring Row 14-15 in one row also and delete the empty line and merge the comment section. While I import the table in power query, it shows one row as nil value, so...

Hello all. I am struggling to figure out what is going on. I have a power bi file that is pointing to a folder, that contains over 70 .csv files. Each file is around 200 Mb. I have been working with the power query editor all day. I finally had what I *thought* was a finished product...

Hello. I am new to using Power Query and have gotten stuck on something and am looking for some help. In a data set I would like to categorize the values in one of the fields using some kind of If/Then/And/Or logic. I can figure out the logic if I was using an Excel formula, but I am...

I have a data table that I query from one shared department spreadsheet. I pull that data into my spreadsheet with Power Query, I don't perform any special steps, just import. I then reference that DATA[Wire 1] and DATA[Wire 2], for example. If I put a column [Wire 1.5] in between [Wire 1] and...

I inherited 5 excel files between them have >100 individual pivot tables across multiple worksheets. Some sheets have multiple tables. I’d like to extract the file name, worksheet, cell location and most importantly, pivot table setup conditions (filter selections, rows, columns & values) for...

Hello all, I have a problem working with Excel using Power Query to bring in 79 files with a total of 113MB. These files are .xlxs files averaging 1.4 MB. The files are located on a folder on my desktop. When I go through the power query process, I open PQ, then select the folder, Transform...

Hi, If I am in Excel I can load a table to power query close add to data model , then go to power pivot, check I have what I want and if it is not right or I have forgotten to do something I can go back to power query make the changes I want and they will be reflected in the power pivot table...

Hello there, Although this is predominatley a Power Query Question, the criteria are obtained from an Excel Sheet and the output placed on 1 Excel sheet. I have some PQ code (Windows Excel 2016) that will load a single pre-specified CVS file into Excel as follows: Excel Sheet1: Excel Name...