Fill blanks with last known value

This custom expression will fill the blanks with last valid value. Will replace blanks

Last([B]) over (allPrevious([A])) as [C]

If you have only one row with blanks or you don't want to rely the value on any other column then create a calculated column with 'rowid() as [A]' and use the same expression as above. 

1 comment:

Anonymous said...

If I want that the filling process depends of another variable, how can I do it?