Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.