Forum Discussion
GeorgeG
Helper I
Helper ILookup a non blank value if two values are the same and return it.
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...
GeorgeG , A new column
New column =
var _1 = maxx(filter(table, [itemname] = earlier([itemname]) && [description] <> blank()), [description] )
return
if(isblank( [description] ) , _1, [description] )
amitchandak
Super User
Super UserGeorgeG , A new column
New column =
var _1 = maxx(filter(table, [itemname] = earlier([itemname]) && [description] <> blank()), [description] )
return
if(isblank( [description] ) , _1, [description] )
GeorgeGHelper I
Helper IPerfect, thank you very much!