The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to 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
= 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]}})
= 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]}})
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