Forum Discussion
Solved
Fill column with lookup minimum value
Hi all
I have the following table:
| Company | created date | original date | created by | created by fix |
| 1 | 1 | john | john | |
| 2 | 1 | kim | john | |
| 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?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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] ) )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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
