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")
Tito's avatar
Tito
Helper IV
2 years ago

Hello SamWiseOwl 
I have calculated it with a mesaure:


Dynamic Group =
VAR SelectedGroup = SELECTEDVALUE(GoupParameter[Group])
RETURN
IF(
    ISBLANK(SelectedGroup),
    BLANK(),
    IF(
        COUNTROWS(
            FILTER(
                Tabelle,
                Tabelle[Group] = SelectedGroup &&
                Tabelle[Name] = MAX(Tabelle[Name])
            )
        ) > 0,
        SelectedGroup,
        "non " & SelectedGroup
    )
)
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.