fill column value based on value in another column

[pathakpeeyush]

I am having following table, I want the 'Value' column to be filled for VCF and VCT based on Value of VCL where SO,BN and MV is same for VCL,VCF and VCT.

Name	Col1	SO	BN	MN	Value
VCL	5449	11315906	C721578E	MS6108005EN	A1
VCF	2048	11315906	C721578E	MS6108005EN
VCT	2745	11315906	C721578E	MS6108005EN
VCF	6374	11327179	C721578G	MS9666005EN
VCT	2048	11327179	C721578G	MS9666005EN
VCL	1765	11327179	C721578G	MS9666005EN	A2

 The output table should be 

Name	Col1	SO	BN	MN	Value
VCL	5449	11315906	C721578E	MS6108005EN	A1
VCF	2048	11315906	C721578E	MS6108005EN	A1
VCT	2745	11315906	C721578E	MS6108005EN	A1
VCF	6374	11327179	C721578G	MS9666005EN	A2
VCT	2048	11327179	C721578G	MS9666005EN	A2
VCL	1765	11327179	C721578G	MS9666005EN	A2

experts, please help me on this. @amitchandak, @parry2k 

[amitchandak]

@pathakpeeyush , Try a new column like

if(isblank([Value]),maxx(filter([MN] =earlier([MN]) && not(isblank([Value]))),[Value]),[Value])

[pathakpeeyush]

I tried this insted- 

if(isblank([Value]),MAXX(FILTER('Table','Table'[MN]=EARLIER('Table'[MN])),[Value]),[Value]) 

but it's returning a new columns with same data in Value column.

[v-easonf-msft · Accepted solution]

Hi, @pathakpeeyush 

Your column type is "text", I would suggest you to use [Value]=" "   to replace isblank([Value]

So please change your formula of calculated column as below:

Value2 = if([Value]="",MAXX(FILTER('Table','Table'[MN]=EARLIER('Table'[MN])),[Value]),[Value]) 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pathakpeeyush]

Thanks for responding. It's showing error msg as- Too few arguments were passed to the FILTER function. The minimum argument count for the function is 2.