Lookup a non blank value if two values are the same and return it.

[GeorgeG]

Hi,

I am looking to create the final column in the table below in PowerBI (replicated in excel for an example).

The idea is to use the Custom column instead of the [Description] column, to replace the blanks. Each Item Name that has the same value should return the description value which is not blank. 

[amitchandak · Accepted solution]

@GeorgeG , A new column

New column =

var _1 = maxx(filter(table, [itemname] = earlier([itemname]) && [description] <> blank()), [description] )

return

if(isblank( [description] ) , _1, [description] )

[GeorgeG]

Perfect, thank you very much!