Forum Discussion

Tito's avatar
Tito
Helper IV
2 years ago
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      
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    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")
SamWiseOwl's avatar
SamWiseOwl
Super User
2 years ago

Well Done!

Tito's avatar
Tito
Helper IV
2 years ago

Hello SamWiseOwl 

unfortunately does not work very well:

 

 

  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    2 years ago

    Dynamic Group =
    var Namecur = SELECTEDVALUE('Group'[Please choose group])--Current Name
    VAR SelGroup = SELECTEDVALUE('Group'[Please choose group])
    var grouphigh =
    CALCULATE(COUNTROWS(List),all(List[Group]), List[Group] = SelGroup)
    return
    if(
       grouphigh > 0, "Group " & Namecur, "non Group "& Namecur)
    • Tito's avatar
      Tito
      Helper IV
      2 years ago

      Hello SamWiseOwl 

      perfect , it worked. Thank you very much.