Forum Discussion
Solved
Move 1 row up
So... My Source data is skewed up resulting to data in Column1 to be on a different Row. In Excel, I can easily Edit JUST this column to move up & problem solved. In PowerBI Edit Query, I have been b...
Hey,
in the Query Editor
- mark Column1
- from the context menu choose Fill -> up
- mark Colum2
- from the filter menu in column heacher chooe Remove empty
Hopefully this is what you are looking for
Regards
Tom
Hey,
in the Query Editor
- mark Column1
- from the context menu choose Fill -> up
- mark Colum2
- from the filter menu in column heacher chooe Remove empty
Hopefully this is what you are looking for
Regards
Tom
I was thinking along those lines but Fill up doesn't work on my dataset, The Blank looks blank but Fillup doesn't fill it up.
OK. I change the datatype of Column1 and fill up now works. Thanks
Glad, you found your solution