Conditional Column

[prajwaljm24_]

i have a data set which consists of column such as session id and project id 

sessionId	projectId
995F966D-789D-4520-A4B0-000B09C6838A	5211271
995F966D-789D-4520-A4B0-000B09C6838A	null
995F966D-789D-4520-A4B0-000B09C6838A	null
DBE4F4BA-8B3A-4750-B86F-000BE0FF0CAF	null
DBE4F4BA-8B3A-4750-B86F-000BE0FF0CAF	null
DBE4F4BA-8B3A-4750-B86F-000BE0FF0CAF	null
DF7DC6A0-13B5-453D-87F8-00153D5F013F	null
DF7DC6A0-13B5-453D-87F8-00153D5F013F	null
DF7DC6A0-13B5-453D-87F8-00153D5F013F	5212095
1177DD53-CCC4-4B15-90A9-0020BA45D781	null
1177DD53-CCC4-4B15-90A9-0020BA45D781	null
1177DD53-CCC4-4B15-90A9-0020BA45D781	5213617

here i need to replace the null values if the session id is same and if any of its corresponding project id is not null ,
how can i create a conditional column for this ?
for example "995F966D-789D-4520-A4B0-000B09C6838A" is repeating thrice and only one row has the project id value "5211271" now for the null rows i need to replace it with "5211271" 
how can i achieve this 

thank you 
@

novicepbixer

@

Greg_Deckler

@

[amitchandak]

@prajwaljm24_ , Try a new column

if(isblank([project id]), maxx(filter(Table, [sessionId] =earlier([sessionId]) && not(isblank([project id])) ), [Project id]) , [project id])

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s

[prajwaljm24_]

Hi thank you for the solution 
can you help me achieve this in power query editor