Forum

Hi Adolfo, The syntax is a bit different: = Table.AddColumn(#"Changed Type", "Custom", (x)=> Table.SelectRows(Table2,each _[Column1]=x[Column...

Hi Andrea, I'm not seeing Table.Buffer anywhere. There is another function: #"Invoke Custom Function1", can you provide the query code for that? Th...

Hi Franz, I'm a newbie in cascading costs, so it will be important for me to see a sample of the source data and how the result should be. Pleas...

Hi Patrick, Indeed, as Mynda said, you need to have a manual table with comments and merge it with the data query from folder. Using an index co...

Might be just floating point calculation errors, simply round those columns to 2 or 4 decimals. Those are not funny chars, it's a scientific number...

Hi Paul, Add a step with Keep Rows with errors, this way you'll have them all on screen. After you identify the errors, you can just remove the Kee...

Hi Salman, Try both places (Source, step 9), see which one is faster. Buffering is a trial-error process, not a fail-proof recipe, sometimes works,...

Hi Salman, Background data preview might help only when you are in power query editor, that's the place where the preview is used. In a normal refre...

Hi Fabian, When you start the query from Web, make sure that you click on the left side the folder, not on one of the tables and click on Transform...

You need to make sure you can access that folder from your computer. Try using the folder path in file explorer, see what happens: \usepa.sharepoin...

Hi Patrick, Update the following code in your file: 'Create new PDF file name including path and file extension Dim PDFName As String PDFName ...

Anyway, I duplicated one of the files, check the attached file. The process goes like this: The main query gets the files from the folder. We ad...

that folder has one file only, not 2, please check again. Please upload the files here in forum, no need to add links here. There is an attachme...

Group By, this is the answer. Choose the grouping keys, then For the first column that will be added, choose Sum for the Balance column as aggregat...

See an example attached. I have separated the headers from data, joined them back, then appended the data. (note: you can attach a file to forum...