power query advance

Dear All, I am not sure how to unpivot data in Power Query to get the desired outcome, please see the picutre. Currently the data layout is in a way where all the months are in column for Actual, Budget, Forecast and WTE for each month. My aim is to have data in a way where I can easily use...

Dear All, I am trying to do a Vlookup with if statement in Power Query but unable to. in Excel I have done in this way --> =IF(P3="Recruited",VLOOKUP(AA3,'Sheet1'!A:B,2,0),) Please if you could help me on how to do this in Power Query? Many Thanks.

Dear All, I am pulling data from 3 different sources using power query. I need to do reconciliation whether the hours worked are matching from these sources. Below are the headings of each source. Table 1: A/C Code - Employee No - Month - Hours Worked Table 2: A/C Code - Employee No - Month -...

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

Dear All, Currently, I am getting the data from a folder and it has few fixed text data columns and then months column with numbers in them. Every month I received the updated file which has the latest month data but my query does not pick the data for the new month and manually I have to...

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 am using power query for the very first time and facing an issue in developing a formula of SUMIFS. The formula will be =SUMIFS($T$2:$T$1048576,$D$2:$D$1048576,D2,$W$2:$W$1048576,W2)/XLOOKUP(W2,VEH!D:D,VEH!E:E) Could you please assist to develop the formula in power query...

Hello, I appreciate some advice here. I have a connection with another csv file but its sheet's name changes every day after it gets replaced with a new extracted file. The sheet name is in this format Data20210721 and it keeps changing every day. So next day it will be Data20210722 after a new...

All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......

Hi Guys & Girls Here we go head scratcher of the month ? I will try my best to explain without boring you to death. I have three connection files in Power Query that I know what I want to do but not sure which path to go down. So let me explain the table names and what they do:- 1...

Hello, I want to create a query that uses a paramater taken from my excel worksheet. i have managed to do this with this code; let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Filtered Rows" = Table.SelectRows(Source, each ([StepTag] = GetValue("Filter"))) in...

hi there well yesterday i had add power query for my Microsoft excel 2010, so i am really new to this. so my question is that power query can add columns, but no rows? unless if we add column then we pivot it, but even adding columns has to be manual, i mean i dont know yet how to make an...