Forum Discussion
Solved
add new column in PowerQuery
Hello, I would like to add a new column in PowerQuery. If a customer has Group A, it should return "Group A", otherwise "non Group A". Best regards Tito Data: Rsult
Hi Tito ,
You could create it as a Calculated column in the front end=
Group A =var Namecur = [Name] --Current Namevar grouphigh = COUNTROWS(FILTER(List, Table[Group] = "A" && List[Name] = Namecur ))returnif(grouphigh > 0, "Group A", "non Group A")
Hi Tito ,
You could create it as a Calculated column in the front end=
Group A =
var Namecur = [Name] --Current Name
var grouphigh = COUNTROWS(FILTER(List, Table[Group] = "A" && List[Name] = Namecur ))
return
if(
grouphigh > 0, "Group A", "non Group A")
Hello,
it worked. Thank you very much!
Best regards
Tito
Tito fantastic! If you could mark it as a Solution I'd appreciate it!
You already did, thank you so much 🙂