Forum Discussion
Solved
Data Transformation in Power Bi
I need helpt to tranform my excel data from Picture 1 to Picture 2 in Power Bi: Picture-1: Picture-2: Can someone please let me know if we can do this in Power Bi ?
I also recorded a video for you
Go the tranform data in power query section and use the standard function Fill - Down.
It will replace the null value of your column with the previous not null value.
Then import the data in the model with save and load button.
MARK AS A SOLUTION IF I HELP YOU TO RESOLVE YOUR PROBLEM.
Regards
Luca D'Elicio