Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi Gurus,
I have data ordered by the latest to older. I have a column where I only want to remove the first few blank rows. Not all the rows that are blank because I want to perform a "fill down" fuction later to fill the blank.
Is there a way to do it?
Thanks,
Raymond
Solved! Go to Solution.
Hi @clubspec ,
If I understood correctly your requirement you want to go from here:
To here:
Hi @clubspec ,
I usually use this option specifying any number of top rows to be removed and then edit the function on the Formula Bar. 
Hi @clubspec ,
If I understood correctly your requirement you want to go from here:
To here:
Thank you Mallorca, you are legend!
I made it work by going into Advanced Editor and use Table.Skip. However, do you know if there is button made for this Table.Skip fuction?
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
