Hi Team,
In excel, we can refer to above cell for row index. =IF(B3=B2,D2+1,1).
Is there any power query equivalent formula for this. Please see attached for reference.
Thank you
Regards,
Aye
Mcode
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"Attribute"}, {{"Data", each _, type table [#"Period: - Fortnightly"=text, Attribute=text, Value=number]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Data],"INDEX",1,1)),
#"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Period: - Fortnightly", "Value", "INDEX"}, {"Custom.Period: - Fortnightly", "Custom.Value", "Custom.INDEX"}),
#"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Data"}),
#"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Custom.Period: - Fortnightly", "Attribute", "Custom.Value", "Custom.INDEX"})
in
#"Reordered Columns"
Many thanks, Alan.
This is all I required.
Regard,
Aye
