Lookup value in a column and fill new column in same table

[yellow43]

Hello,

I am new with DAX and I am having some issues with the following:

1. Table has a column 'first_visit' (date type) with some null values;

2. some rows with same 'id' have column 'first_visit' with data and other rows have null values

Output desired:

I have tried LOOKUPVALUE, ISBLANK functions but I am having some syntax problems.

Thank you in advance for your help.

 

[v-zhangti · Accepted solution]

Hi, @yellow43 

You can try the following methods.

New =
IF (
    [first_visit] = BLANK (),
    CALCULATE (
        MIN ( 'Table'[first_visit] ),
        FILTER ( 'Table', [id] = EARLIER ( 'Table'[id] ) )
    ),
    [first_visit]
)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yellow43]

Thank you @v-zhangti ! It worked just fine.

Meanwhile I have tried and came to this solution:

newFirstVisit = CALCULATE (
MIN ( Table[FirstVisit] );
ALLEXCEPT ( Table; Table[Id] )
)

Please let me know if this is also an option. Result was what I expected, but this might not be the best solution... is it ok?

[vapid128]

Calculate(

    Min(table[fisrt_visit],
    Filter(
        table,
        table[id]=eariler(table[id]) &&

        table[first_visit] <> blank()
    )
)