Forum Discussion
jcastr02
Post Prodigy
Post Prodigyget 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"}),";")
spinfuzer
Solution Sage
Solution SageYou 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"}),";")
jcastr02Thank you This worked, sorry that last row was a mistake on my part base would have been included