Forum Discussion
bernate
Helper III
Helper IIICustom Column Based on Groups in 2 Other Columns
Hello, I am trying to create a custom column that would designate which employees are still "in training." My data looks like below: Employee Name Training TrainingStatus DateTime Trai...
let status = [Complete = "Training Complete"], Source = your_data, group = Table.Group( Source, {"Employee Name", "Training"}, { {"rows", each _}, {"status", (x) => Record.FieldOrDefault(status, Table.Max(x, "TrainingStatus DateTime")[Training Status], "In Training")} } ), result = Table.ExpandTableColumn(group, "rows", {"TrainingStatus DateTime", "Training Status"}) in result
AlienSx
Super User
Super Userlet
status = [Complete = "Training Complete"],
Source = your_data,
group = Table.Group(
Source,
{"Employee Name", "Training"},
{
{"rows", each _},
{"status", (x) => Record.FieldOrDefault(status, Table.Max(x, "TrainingStatus DateTime")[Training Status], "In Training")}
}
),
result = Table.ExpandTableColumn(group, "rows", {"TrainingStatus DateTime", "Training Status"})
in
result
bernateHelper III
Helper IIIThank you, I ended up using your code as the solution.