Forum Discussion
Solved
Looking to match value from one colu
Hello PowerBI Experts, I am a learner and have been stepping into new challenges each day. I am hoping you will be able to steer me in the right direction. I have candidates in each order and n...
NewStep=Table.Combine(Table.Group(PreviousStepName,"Order ID",{"n",let a=List.Max([Stage]) in Table.AddColumn(_,"Highest Application Status",each if [Stage]=a then [Application Status] else null)})[n])
wdx223_Daniel
Community Champion
Community ChampionNewStep=Table.Combine(Table.Group(PreviousStepName,"Order ID",{"n",let a=List.Max([Stage]) in Table.AddColumn(_,"Highest Application Status",each if [Stage]=a then [Application Status] else null)})[n])
Thank you!
I will give it a try later today and let you know if it worked:)