Forum Discussion

barthand16's avatar
barthand16
Frequent Visitor
3 years ago

How to replace blank values with last known value

Can someone help me write a dax or coloumn formula that will allow the data set to fill in the blank values with the last know value. 

 

For Instance:
79 should be present in "2322" & 113 should be present in 2320 so looking back and forward to thelast known value. Would like to default to the previous but if no previous then future. 

 

The coloumns are from a date table i created and the values are from my data table. The values are a sum from the table. 

 

Thank you!

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    barthand16 , Assume the column name for 2322 is ID and value 11 and 79 are coming measure M1

     

    if(isblank([M1]) , calculate(lastnonblankvalue(Table[ID], [M1], filter(all(Table[ID]) , Table[ID] < Max(Table[ID]) ) ) , [M1] )

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    could you share your pbix-file? Or create an example file which reproduces your issue?