Re: Dynamically delete rows in column

Anonymous · ‎09-17-2021

Hi guys,

I am looking for a way to dynamically keep a range of rows in power query.

I have multiple standard worksheet files that are combined in one query. But the data starts at a different row per file. I already have combined the files and i am now working in "Transform sample File". I would like every file to start with 3 zeros and then start with the data in row 316 (see image) and then end with 3 zeros.

Can anyone help me with this?

CNENFRNL · ‎09-17-2021

Add index column since you already know the starting row of dataset.

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Anonymous · ‎09-20-2021

For this example i do know indeed but for the other 200 files i do not know the starting row of the data and it would be nice if that coould be automatically solved...