How to fill a column with a if condition

[SRP]

I'm looking to understand how to filldown (or up) a column with a if condition, using PowerBI.  As you can see i have a "string_values" with null values. When the instance are the same (same number), i want to fill the string values. 

I tried this code but he doesn't work : 

New =

IF (

Sheet1[string_value] = BLANK ();

CALCULATE (

LASTNONBLANK ( Sheet1[string_value]; Sheet1[string_value] );

FILTER ( ALLEXCEPT ( Sheet1; Sheet1[instance] ); Sheet1[string_value] = EARLIER ( Sheet1[string_value] ) );

Sheet1[string_value]

)

Thanks for your help

[v-jingzhang]

Hi @SRP 

@ryan_mayu 's solution should work. Have you tried it? If you have solved it, accept a proper reply as solution or share your own solution if there is a better one. This will help the community! Thank you.

Best Regards,
Community Support Team _ Jing

[ryan_mayu · Accepted solution]

@SRP 

is this what you want?

Column = 
VAR _text=maxx(FILTER(asmt_assessment_instance_question,asmt_assessment_instance_question[instance.task_id.number]=EARLIER(asmt_assessment_instance_question[instance.task_id.number])),asmt_assessment_instance_question[string_value])
return _text

[SRP]

Exactly !

[SRP]

In first i saw only the screen and not the column. When i try it, the error is : 

"EARLIER/EARLIEST refers to an earlier row context which doesn't exist"

[ryan_mayu]

@SRP 

are you using a DAX to create a column? 

[SRP]

I tried with DAX yes but it doesn't work either. But i almost did it with Power Query, still doesn't work anyway

[ryan_mayu]

@SRP 

pls see the attachment below.

[amitchandak]

@SRP , You have fill up and fill down option in power query.

You are using a dax column, there the logic needs to be based on column have to value.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[SRP]

I don't really know how to share that, but i got you a excel file with usefull data here : 

https://we.tl/t-usWasFJpdH

I tried to do it with Power Query but i can't incorporate the if condition with