Forum Discussion

What3lse's avatar
What3lse
New Member
3 years ago

Fill Missing Value

Hello everybody, I'm discovering DAX language and I have some difficulties to do thant I want. I will explain you my issue.   in the field "Prodline", I don't have always value, I have only one w...
barritown's avatar
barritown
Solution Sage
3 years ago

Hi 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,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian