Forum Discussion

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
4 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_c...
Need Help
davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 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
    Icon for Responsive Resident rankResponsive Resident
    4 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?