Forum

Hi Peter, Sorry for the late reply. Try this: Private Sub cboPrintBus_Click() Dim shData As Worksheet, shGroup As Worksheet Dim arrSh As Va...

Hi Kevin, Hard to say without seeing how the functions are built. For example, a function will not work if the function itself is supposed to chang...

Hi Jim, Use this query: let Source = Excel.CurrentWorkbook(){[Name="Students2"]}[Content], #"Removed Columns" = Table.RemoveColumns(Source,{...

There are no limits, you can do anything. Here is an example: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Headers = Table.Co...

Hi, try the file attached.

Hi Alexios, It's not recommended to do that in PQ, it's better to make the aggregations in a pivot table, see image attached. The table you have is...

Hi Adam, Basically, the answer is already in the error message: DataFormat.Error: We couldn't convert to Number. Details: - That means you do...

Hi Alvin, PQ is designed to aggregate data, rather than splitting data. Queries cannot replicate themselves to load a different data set into a ...

Hi Chris, To get the previous row value, you have more options. One of them is to add 2 index columns: one starting from 0, and the other one st...

Hi Alberto, The SelectRows condition: each ([Numero settimana] = ParaWeek) should be: each if ParaWeek=null then true else ([Numero settimana] =...

I have no idea what changes you have to do in the function. Usually, you have to avoid using hard typed file paths, or column names. Use generic funct...

Do you have many records? Try using Table.Buffer in the steps just before Add Column steps.

The changes you make in a sheet are not reflected instantly in power query and in power pivot. You need to update the queries: Datatab-RefreshAll

Hi Linda, Don't think you even need grouping. Please test the attached query, you have examples for how to find the last event for each Key, sum...

Hi Patrick, Here are the changes needed: Replace ".pdf" with ".docx" in the following line: PDFFile = DestFolder & Application.PathSepara...