Fill Missing Value

Question

Hello everybody,I'm discovering DAX language and I have some difficulties to do thant I want.I will explain you my issue.&nbsp;in the field "Prodline", I don't have always value, I have only one when "MvtType" is 101.I would like to complete Field "Prodline" when data is missing and take data when "ProdOrder" is same&nbsp;I tried to mix together function IF and LookUpValue but It's not working&nbsp;You can find an extract of my table below&nbsp;Thanks you a lot.&nbsp;Regards&nbsp;🙂&nbsp;table [Trial_Table]&nbsp;IDProdOrderItemCodeMaterialDocMvtTypeQtyUnitBatchRemQtyProdLineDateProdLine (groupes)Qty CorrigéNew Prodline150954100005820041ZZ70496221-05XM60297058321012400PC0017964847&nbsp;PER17/08/2023 06:3850 - PER2400&nbsp;151079100005820041ZZ70496221-05XM60297076841012134PC0017964847&nbsp;PER17/08/2023 11:2850 - PER2134&nbsp;151148100005820041ZZ70496221-05XM60297080941012133PC0017964847&nbsp;PER17/08/2023 13:4350 - PER2133&nbsp;151078100005820041ZZ70496221-05XM60297076821022400PC0017964847&nbsp;&nbsp;17/08/2023 11:28(Vide)-2400&nbsp;151147100005820041ZZ70496221-05XM60297080921022134PC0017964847&nbsp;&nbsp;17/08/2023 13:42(Vide)-2134&nbsp;150716100005820042ZZ70496221-05XM60297037761012146PC0017964849&nbsp;PER17/08/2023 00:1850 - PER2146&nbsp;151216100005820043ZZ70496221-05XM60297086111012284PC0017964850&nbsp;PER17/08/2023 16:4350 - PER2284&nbsp;151219100005820043ZZ70496221-05XM60297086261012283PC0017964850&nbsp;PER17/08/2023 16:4850 - PER2283&nbsp;151217100005820043ZZ70496221-05XM60297086221022284PC0017964850&nbsp;&nbsp;17/08/2023 16:48(Vide)-2284&nbsp;150992100005820044ZZ70496221-05XM60297061241012222PC0017964851&nbsp;PER17/08/2023 07:1850 - PER2222&nbsp;151456100005820047ZZ70496221-05XM60297093421012214PC0017964854&nbsp;PER17/08/2023 23:2450 - PER2214&nbsp;

barritown · Answer

Hi&nbsp;What3lse,If I correctly understand the logic for filling missing values, you could use a calculated column like this:In plain text for convenience:ProdLine Updated = 
IF ( NOT ISBLANK ( [ProdLine] ),
     [ProdLine],
     VAR CurrentProdOrder = [ProdOrder]
     VAR Result = MAXX ( FILTER ( Data, [ProdOrder] = CurrentProdOrder ), [ProdLine] )
     RETURN Result )Best Regards, AlexanderMy YouTube vlog in EnglishMy YouTube vlog in Russian&nbsp;

Forum Discussion

Fill Missing Value

1 Reply

Related content

Fill missing dates with previous value

Filled map

Total value missing in calculated column

Generating Missing Data

missing data

ID	ProdOrder	ItemCode	MaterialDoc	MvtType	Qty	Unit	Batch	RemQty	ProdLine	Date	ProdLine (groupes)	Qty Corrigé	New Prodline
150954	100005820041	ZZ70496221-05XM	6029705832	101	2400	PC	0017964847		PER	17/08/2023 06:38	50 - PER	2400
151079	100005820041	ZZ70496221-05XM	6029707684	101	2134	PC	0017964847		PER	17/08/2023 11:28	50 - PER	2134
151148	100005820041	ZZ70496221-05XM	6029708094	101	2133	PC	0017964847		PER	17/08/2023 13:43	50 - PER	2133
151078	100005820041	ZZ70496221-05XM	6029707682	102	2400	PC	0017964847			17/08/2023 11:28	(Vide)	-2400
151147	100005820041	ZZ70496221-05XM	6029708092	102	2134	PC	0017964847			17/08/2023 13:42	(Vide)	-2134
150716	100005820042	ZZ70496221-05XM	6029703776	101	2146	PC	0017964849		PER	17/08/2023 00:18	50 - PER	2146
151216	100005820043	ZZ70496221-05XM	6029708611	101	2284	PC	0017964850		PER	17/08/2023 16:43	50 - PER	2284
151219	100005820043	ZZ70496221-05XM	6029708626	101	2283	PC	0017964850		PER	17/08/2023 16:48	50 - PER	2283
151217	100005820043	ZZ70496221-05XM	6029708622	102	2284	PC	0017964850			17/08/2023 16:48	(Vide)	-2284
150992	100005820044	ZZ70496221-05XM	6029706124	101	2222	PC	0017964851		PER	17/08/2023 07:18	50 - PER	2222
151456	100005820047	ZZ70496221-05XM	6029709342	101	2214	PC	0017964854		PER	17/08/2023 23:24	50 - PER	2214