Find Value that is not equal to blank() and copy it into a column

[KevBI]

Hello Community!

I have a table with various "ProjectIDs", "Project names" and "Project Owners". 
Same "Project Names" occur often in the table, but only 1 row is filled with a "Project Owner".

Now I want to copy cells that are filled with the "project owner" Name into the according "Project Owner" Cells that are blank.

Thanks for the help!!

Project_ID	Project_Name	Project_Owner
1	Hedon
2	Hedon
3	Hedon	Owner_A
4	Beton
5	Beton	Owner_B
6	Gale
7	Gale	Owner_C
8	Gale

[amitchandak]

@KevBI , new column in DAX

Project_Owner new=

if(isblank([Project_Owner]), maxx(filter(Table, [Project_ID] = earlier([Project_ID]) ) , [Project_Owner] ),[Project_Owner] )

[KevBI]

this doesn't work sadly, maybe I didn't clarify my problem enough.

If I look at the project Hedon, i want the new column to display Project Owner A in every column.
With your solution it copys not only the filled project owners, but also the blank ones.

[amitchandak · Accepted solution]

@KevBI , Sorry you need to use project name

Project_Owner new=

if(isblank([Project_Owner]), maxx(filter(Table, [Project_Name] = earlier([Project_Name]) ) , [Project_Owner] ),[Project_Owner] )

[KevBI]

I found an error, maybe you can help me with that again!

So when the count of rows in Project_Owner that are blank is equal to the count of rows in Project_Owner with a name in it, it copys not only the filled project owners, but also the blank ones.

Thank you!

[KevBI]

This works perfectly, thank you!