Explode and duplicate Rows
Dear all, I have a little problem on Power Query, In fact, I integrated TABLE1 from an Excel file and in Power BI and I want to transform the table and explode it according to the number of days off (by modifying the date each time of END) as shown below. there is any solution to do it in Power Query PBI?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
