Forum Discussion

Bertenvanloover's avatar
Bertenvanloover
Frequent Visitor
3 years ago
Solved

Find Text from List in Rows with same ID as current row

Hi, I could use some help finding a way to do the manipulation below in Power Query: I want to create a custom column "Already_Approved" that shows * "Yes" when chronologically² the last row in the...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    NewStep=let a=Table.Group(PreviousStepName,"Document_ID",{"n",each Table.Sort(_,{"Date",1}){0}[Transaction]}) in Table.AddColumn(PreviousStepName,"Already_Approved",each if a{[Document_ID=[Document_ID]]}[n]="Approved" then "Yes" else "No")

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

NewStep=let a=Table.Group(PreviousStepName,"Document_ID",{"n",each Table.Sort(_,{"Date",1}){0}[Transaction]}) in Table.AddColumn(PreviousStepName,"Already_Approved",each if a{[Document_ID=[Document_ID]]}[n]="Approved" then "Yes" else "No")