Forum Discussion
Solved
Fill down values with DAX calculated column
Hi All I need help trying to fill values down based on the date I have for each staff. Please see the example below with the expected column to be created along with the link to the sample data...
Please try
Employment Status New = VAR CurrentDate = TableName[Date] VAR CurrentStatus = TableName[Employment Status] VAR CurrentIdTable = CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[ID] ) ) VAR NoBlanksTable = FILTER ( CurrentIdTable, TableName[Employment Status] <> BLANK () ) VAR NoBlanksTableBefore = FILTER ( NoBlanksTable, TableName[Date] < CurrentDate ) VAR LastDateWithData = MAXX ( NoBlanksTableBefore, TableName[Date] ) VAR LastStatus = MAXX ( FILTER ( NoBlanksTableBefore, TableName[Date] = LastDateWithData ), TableName[Employment Status] ) RETURN IF ( ISBLANK ( CurrentStatus ), LastStatus, CurrentStatus )
Just wanted to add that my code retrieves the last available value before the blank incase you have multiple available values per Id with blanks inbetween the values.
