Forum Discussion

waldnerr's avatar
waldnerr
Icon for Helper I rankHelper I
4 years ago
Solved

Replace empty value with value from previous change documentation row value

Hi,   I have a table with change documentation values, where only the columns, where the user has changed something in the frontend are stored. The other rows with fact data stay blank. My problem...
Need Help
  • mohammedadnant's avatar
    mohammedadnant
    4 years ago

    hi waldnerr 

     

    You can do this using Power Query Editor

    Sort your data based on your criteria and then select the Current Budget --> on ribbon --> Transform --> Fill --> Down.

     

    This will fill you with the recent data in the blank cell.

mohammedadnant's avatar
mohammedadnant
Icon for Impactful Individual rankImpactful Individual
4 years ago

hi waldnerr 

 

You can do this using Power Query Editor

Sort your data based on your criteria and then select the Current Budget --> on ribbon --> Transform --> Fill --> Down.

 

This will fill you with the recent data in the blank cell.