How to generatively fill 'null' cells

Filled_Name = IF( ISBLANK('YourTableName'[Name]), CALCULATE( FIRSTNONBLANK('YourTableName'[Name], 1), FILTER( 'YourTableName', 'YourTableName'[Account_ID] = EARLIER('YourTableName'[Account_ID]) && NOT(ISBLANK('YourTableName'[Name])) ) ), 'YourTableName'[Name] )

Try this column If it helps Mark as a solution!

For more Power BI tips and trick you can visit https://powertipstricks.blogspot.com/ blog

Thanks in advance

Anonymous 

output 

sample data used  :

steps 

step1 : create a config table in power query  , as follow : 

1.1 duplicate your table.

1.2 remove duplicates

1.3 filter column1 on not blank 

step2 : 

merge this table with your table on id =  id  and expand the column :  account_name ( in my scenario i named it Column1modified .

step3 : use the replace value feature under transform tab :  ( be sure yo select your orignial account_name column ) 

enter any data to replace with . 

in the code , modifiy the replace 1 with each [ column1modified]: 

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠: