Compare values in 2 colums return value from 3rd column in a new colum
Hi all, Trying to get my head around the following in Power Query. I'm trying to compare 2 columns from 2 seperate table to find a common value I have table Shipment_Data with column Consol ID and table Consol_Data with colum Reference. The values in column Reference should be contained in the colum Consol ID, if it matches it should then copy the value from table Consol_Data, column MAWB from the same row and create a new column in table Shipment_Data with the respective value from table Consol_Data, column MAWB As there might be multiple values in column Consol ID.Delete the first 10 rows of each file on a "multiple file" table
Hi all, I have a quite specific question for you : I made a query with parameters to get the values of multiple excel files (hosted on sharepoint) into one single table, that I will call "multiple file table" or "consolidation table". Because all these files have exactly the same structure, I can see them in one single Power BI Table with same columns for each. In the applied steps of the Table, I had to remove the First 10 rows of the Excel file (it contains useless values), but it just did it for the 1st file I injected. What I would like is : create a formula to remove first 10 rows each time my Table is processing a new file. (What I did until now is a series of "= Table.SelectRows(#"Renamed Columns", each [field1] <> null and [field2] <> null" ... but it is quite ugly and not developer friendly.) I hope it is clear for you. Many thanks in advance
