Forum Discussion
Solved
get column header for max column
I have below "DE MAX" column that gets the maxiumum value in the row. I'd like to be able to get the column name of the item where the max value was found. At times the max value may be shared betw...
You can add custom column. I am not sure how the last one does not include base.
Text.Combine(List.RemoveItems(List.Transform(List.PositionOf(Record.ToList(_),[DE MAX], Occurrence.All), (x) => Record.FieldNames(_){x}), {"DE MAX"}),";")
You can add custom column. I am not sure how the last one does not include base.
Text.Combine(List.RemoveItems(List.Transform(List.PositionOf(Record.ToList(_),[DE MAX], Occurrence.All), (x) => Record.FieldNames(_){x}), {"DE MAX"}),";")
Thank you This worked, sorry that last row was a mistake on my part base would have been included