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

[Anonymous]

If Column 1, row 1 and 2 are the same, fill up column 3 with value below.

Row 1, column 3 desired outcome is 24-10-2022. Row 14,15,16 remain null or empty.

Row 17, clomun 3 desired outcome is value from row 18

[Anonymous · Accepted solution]

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

[Anonymous · Accepted solution]

= 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]}})

[Anonymous · Accepted solution]

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

[foodd]

How to Get Your Question Answered Quickly