Copy the numbers of blank data based on previous date's number

[jovendeluna21]

Hello,

Is there any way that the blank columns will just copy the previous number? This one is directly connected to a web source so I'm thinking just to create a new column for Total Distributed per 100k and blanks will copy the number of the previous date.

For example January 16, 17, 18 Total Distributed per 100k will be 9,523.97 same as January 15.

In this way, I can normalized the 7 day rolling average.

Herein on this link the pbi file.

https://drive.google.com/file/d/1HLKbdqZgTLd5nWxYzery0g2slMQmKpht/view?usp=sharing

[VijayP · Accepted solution]

@jovendeluna21 

in Power Query Editor -> Transform Tab -> Fill ->Down option will help you to copy the previous cell value to all blanks below. Try that

[jovendeluna21]

Thanks @VijayP !!! That worked!