excel power query

Hello All, I receive an Excel file weekly where the table is already in pivoted format with the below-mentioned headers. Please advise what do I need to do as a power query step to select the column headers marked in green because the columns with date header is subject to change where past...

Does anyone have a VBA solution that would take a Connection only (Excel Power Query) and change it to a data table on a worksheet? And then the same in reverse, data table back to Connection only. I have a rather large file that I refresh each morning, and it includes an Archive Power Query...

I am struggling with DAX Measure to Countif on Measure Result in condition. Count of Items whose result of Measure4 = 0 for the selected Sales Centre and Month (YearMonthNumber). I am trying with this measure =CALCULATE (COUNTA (Data [Item Name]), FILTER(ALL('Data'), [QualificationUpto20] = 0))...

Hello, pretty new to power query and dax, I've used < List.Sum list.firstN / Range and List.Accumulate to create running totals, and an index column in Dax power pivot but I'd like to create one based on a condition, so at simples two columns 'Product ' a b c and 'sales' and create a running...

Hi, Would anyone know where the Transform Sample File step get the column format assignment? In some cases it is incorrect and I do not see how can I change this, if I try to change at this step the amounts i get are whole $ without the cents. Thanks Z

Hi Experts, Is there an advantage in using a power query to analyze multi-filter tables where the primary key is not ID but a unique name or code (not numerical) ? For example: Name Department Access to roles Validity Say, I make Name and Department as another query, remove...

I have a column that I would like to change the values in the cell where there is no error to be the value in another column, if the value is null then I want to replace it with the word "CONFIRMED" What is the proper way of doing this in the editor? example of what I am looking for: Before...

How to count "Same Purchase item Qty total" and "minus Same Sale Qty total " if Qty balance is "0" , not show entry in report Again.

How do I reduce refresh time for power query which loads data from SharePoint. I have disabled background refresh and data preview download in background. Still it's slow. Any solutions? I am loading data from am a online share point online List to excel via power query(only by creating...

Hi all, I need to dynamically insert a row into a table based on a cell value. I'm able to insert the row, but I haven't figured out how to make it dynamic. The row will always go above the row with the value "2270PBAKE" in the STAGE column. I'm using the Table.InsertRows function. For the...

I'm stumped with a requirement and can't seem to get past it (I've tried to scour the internet, and I'm unable to fix it myself, given my lesser experience with Power Query). I could accomplish this using VBA, but the number of records, that need to be processed are shy of half a million...

Hi Excel 2016 -Power Query Need to understand and know How to extract multiple pages data using Power Query. Listing below two websites which has multiple pages of data https://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm...