Forum

Hi Mario, You should add a new column, here is the complete step: NewColumn = Table.AddColumn(#"Changed Type", "CountIf", (x)=> Table.SelectR...

Hi Deena, Add 2 columns to Sample table, with the following formula: Status Desc=RELATED('Status'[Status]) Name=RELATED(Contact[Customer Name...

Hi Deena, Can you upload a sample file with test data? It will be much easier to work on a sample than on imaginary data. You can take a look at...

Hi Ju, Try this instead, if all columns are type number: = Table.TransformColumnTypes(Source, List.Transform(Table.ColumnNames(Source), each {_,...

Hi Jay, You can use the Change event of that worksheet. Put the code below in that worksheet vb module: Private Sub Worksheet_Change(ByVal T...

You can put the code below in the BasketOrder.xlsm and run it, it should delete the rows from other files. Sub DeleteRows() Dim FSO As Object: ...

One of the files is open in another instance of excel. xlApp.Workbooks.Open "F:Department FoldersAccountingGMD Calculator JournalGMD_Calculator_Jou...

You have to open the file in another excel instance. Dim xlApp as Excel.Application set xlApp =New Excel.Application To open the file in this...

First formula looks like an index column. You can use: =ROW()-1 This assumes that the table header is in row 1. If the headers are in the sec...

It will take me a week to write about this 🙂 You will have to read a few articles: The above formula works based on the ISO week date system, wh...

Can you provide sample files, so we can see what values are in column C? These should be full matches, partial matches, case sensitive or not case sen...

If the formula is not added to the new rows, it means that there are multiple formulas or static values in those columns. You should delete the con...

Hi, If you have the age in years, adding a column that multiplies the age by 12 should be enough, normally the age in years should have decimals, s...

No, there is no relationship between tables, a table cannot detect a change in another table. Depends on what that analysis does, but I'm sure that...

Hi Andy, My guess is that you have "predefined" formula in a normal range of cells, waiting for users to fill the data input columns. This way of h...