Forum Discussion

sraj's avatar
sraj
Responsive Resident
3 years ago

Copy data from previous day

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!!

 

 

Need Help

2 Replies

  • davehus's avatar
    davehus
    Memorable Member
    3 years ago

    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's avatar
      sraj
      Responsive Resident
      3 years ago

      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?