Copy data from previous day

[sraj]

Hi,

Is there anyway I can copy the previous days value when it doesnt have any data for the current day?  The day you see here is the linkdate field shown below:

= Table.AddColumn(dbo_uv_pbi_2019_comparison, "Linkdate", each Date.AddYears([wf_dt],+1))

Can someone please advise?  Thank you!!

[davehus]

Hi @sraj ,

In Power Query you can achieve via Transform>Fill>Fill Up.

Hope this helps.

Did I help you today? Please accept my solution and hit the Kudos button.

[sraj]

I tried both fill up and down, that didnt work.  I dont see any change, I am doing this on the value column that's blank correct?