power query excel

Dear All, I need quick help from experts in Power Query. Currently, I have 12 budget columns, each month I receive Budget data and the relevant columns are populated with the budgeted figures and for future months it remains blank. What I want are the columns I have for future months where the...

Dear All, I was wondering if you could help. I have an Annual Budget Column in Power Query. I want to divide it by 12 to get the monthly Budget and then have the result in 12 monthly columns using power query. I have done it using 12 steps. But is there any way to do this in 1 step? Example...

Table1 Name Others Person A I am interested in doing calculus and trigonometry Person B coding, making websites Table2 Column A Subject category websites, mobile application, .. etc Information Technology mathemathics, calculus, trigonometry Math Column A are all the different...

Hi All, I have a start date and an end date... and I'm using a custom column in power query to give me the networkdays: = Table.AddColumn(#"Removed Columns2", "Actual_Number_of_Days", each Networkdays([StartDate],[DueDate],HolList)) This is working as designed... until the DueDate is...

hello anyone please help me to fetch data from below given link after just selecting or changing the date. https://archives.nseindia.com/content/historical/DERIVATIVES/2022/OCT/fo21OCT2022bhav.csv.zip

Good afternoon, I'm currently trying to merge two columns that have similar Article ID's, but one list has 17.000+ positions, the other only has 13.000+ positions. All 13.000 match the ID from the first list. Basically I want to add the new columns from a different database and match them with...

Hi, This is an Advanced problem in M language with a very simple excel formula solution. And after many tryouts with many codes, I am kindly asking for Help, please. I have managed to do the grouped running total in various methods yet could not twist any of the codes to achieve the below...

Hi everyone, I have an issue with one of my pivot table due to a change made in a SQL database. There was a change made in a SQL database which caused data to I guess you can say split after a certain month. So for example in a pivot table a persons name is shown twice because data for a...

I have a spreadsheet with a table containing sales data by supermarket chain, unique store and by date. 80% of the sales are within one chain of stores; the rest of the sales come from the other chain. The chain with the most sales was routinely the most frequent and reliable in updating so I...

Hello there I need to make a excel document where i get live updated data from another excel workbook. im struggling with using the Data -> Get Data -> From File -> From Workbook. my problem is that it seems like i need to have the first document closed down in order for the second document to...

I can use Analyze in Excel to create a connection to my PowerBI dataset but I need to transform the data. How can I connect to the dataset from within Power Query?

I have imported data into the Excel Data Model and I need to transform it. I don't see the data model as a source for Power Query. How can I query the data model?

This may have been answered already but I haven't been able to find it anywhere... I always have a difficult time trying to explain Excel issues and my data is not able to be shared. I have multiple tables that I used 'Append' to bring them together to create one list. As it turned out there are...

I wonder if you can suggest a solution for this business question: A given value created to be a matching lookup key between tables can have multiple records in a transaction file. I need to find the condition where the Lookup value has “conflicting” (different) values in another column between...

Hi there, i am having the following issue. I need to tidy up my data table because i get data in different columns. As an example : Code Descr Column1 Price Column2 Column3 Column4 11 Shirt 5 15 Jeans 5 17 Trousers 5 while the table should be : Code Descr...

Is there a limit to how many times Excel will allow a refresh to a query table within a certain time period? I am constantly facing an issue where I refresh my query tables and they take forever to update causing me to cancel the operation. Sometimes -- not often -- they actually complete in a...

It is two files based query - I do not know how to call it - Pivot/Union or other... The first source is at rows 1 to 6, the second one is from 8 to 16 and the wanted result is at rows 18 to 30. Could it be done with Power query? Any hint of the relations/methods needed will be of great help - I...