Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
GeorgeG
Helper I
Helper I

Lookup 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).

 

GeorgeG_1-1628783064205.png


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. 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@GeorgeG , A new column

New column =

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

return

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@GeorgeG , A new column

New column =

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

return

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

Perfect, thank you very much!

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.