Hi Philip, I am just exploring without using function method is it possible, that is the last custom column if I can insert the running total int...
Hi Philip, I used function produce the following output Field 1 QTY GrpByRunningTotal D001 2 2 D001 4 6 D001 89 95 ...
Hi Francis Attached a simple solution first query, Data>New query>from other sources > From Web, input or if you have the currency...
Hi Dilan, add a custom column Text.Combine(List.Transform(List.Skip(Record.FieldValues(_)),Text.From),",") * Record.FieldValues() means field...
Hi Catalin, Thanks ! you are the expert By the way, table1 is taken from original source by users, and usually they do not want to change the "...
Hi Mynda, I used group by and aggregate Max(M), Tuesday, Wednesday, Thursday and Friday Seems like it works too
Hi Silver, first you need to unpivot the two cross-table in Power Query Editor, then Merge to compare the same items/Attributes, and the differ...
Hi Uwais all done using Power query, please refer to my transformation query in Power Query Editor basically take your Product X Revenue and ...
Phil / Mynda Users got quite a number of worksheets and he got to one by one format as tables, that will be tedious, imagine got 100 over worksheet...
Hi Mynda, when I use Excel.CurrentWorkbook() in a blank query, it don't take in non-table worksheet For your further advise Thank you !
Hi Mynda, understand I got no problem using another blank excel then use from folder method, however I would like to do it within the same file, ...
Hi Purfleet, your VBA is alien to me， can explain the meaning of Set tbl = ActiveSheet.ListObjects("Table1") tbl.Resize tbl.Range.CurrentReg...