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 banging myself and can't solved it. Any suggestions welcome.
| Column1 | Column2 | Column3 | Column4 |
| 9 | $$$ | MMM | |
| $$$ | |||
| 9 | $$$ | MMM | |
| $$$ |
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
4 Replies
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
