Fill column with lookup minimum value

[PowerBITestingG]

Hi all

I have the following table:

Company	created date	original date	created by	created by fix
Google	1	1	john	john
Google	2	1	kim	john
Google	3	1	dum	john
Amazon	4	4	tom	tom
Amazon	5	4	james	tom
Amazon	6	4	jerry	tom

I am trying to obtain that "created by fix" column. Which is basically where created date = original date then use created by

any ideas?

[Anonymous · Accepted solution]

Hi @PowerBITestingG ,

I suggest you to create a calculated column by this code.

Create by fix =
CALCULATE (
    MAX ( 'Table'[created by] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Company] ),
        'Table'[created date] = 'Table'[original date]
    )
)

Result is as below.

Best Regards,
Rico Zhou

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

[jdbuchanan71]

@PowerBITestingG 

Give this measure a try.  You would add it as a calculated column.

Created by fix = 
VAR _CreatedDate =
    CALCULATE (
        MIN ( 'Table'[created date] ),
        ALLEXCEPT ( 'Table', 'Table'[Company] )
    )
RETURN
    CALCULATE (
        MIN ( 'Table'[created by] ),
        'Table'[created date] = _CreatedDate,
        ALLEXCEPT ( 'Table', 'Table'[Company] )
    )