FillUp Table in column 1 based on unique value in column 2

Hi  Anonymous ,

Here are the steps you can follow：

1. In Power Query -- Add Column – Index Column – From 1.

2. Create calculated column.

Flag =
var _min=
MINX(
    FILTER(ALL(Table1),'Table1'[Project]=EARLIER('Table1'[Project])),[Index])
var _flag1=
MAXX(
    FILTER(ALL(Table1),'Table1'[Index]=_min&&'Table1'[Project]=EARLIER('Table1'[Project])),[Project])
var _flag2=
MAXX(
    FILTER(ALL(Table1),'Table1'[Index]=_min+1&&'Table1'[Project]=EARLIER('Table1'[Project])),[Project])
return
IF(
    _flag1=_flag2&&'Table1'[Index]=_min,
    MAXX(
    FILTER(ALL(Table1),'Table1'[Index]=_min+1&&'Table1'[Project]=EARLIER('Table1'[Project])),[Date2]),[Date2])

3. Result:

Best Regards,

Liu Yang

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

= Table.Group(#"Kolommen verwijderd1", {"Projectnummer"}, {{"Aantal", each Table.FillUp(_, {"WIBON Tool"}), type table [Binnen=nullable date, WIBON Tool=nullable date, Projectnummer=text, Aangepast=nullable date]}})