Forum Discussion

MyWeeLola's avatar
MyWeeLola
Icon for Helper II rankHelper II
2 years ago
Solved

Scalar error in addcolumns

Good morning   I have unpivoted a table which gives me an ID column and an Attribute column. I have a lot of attributes to display, so I thought I would try to group them to make it easier for the ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MyWeeLola 

     

    The first method is to right click on the Attribute column and select New group. This feature can help you group values in this column through GUI easily and give you the group column you want. Use grouping and binning in Power BI Desktop - Power BI | Microsoft Learn

     

    The second method is to use DAX to create a calculated column

    Column = SWITCH(TRUE(),
'Table'[Attribute] IN {"Jet","Seaplane","Glider"}, "Plane",
'Table'[Attribute] IN {"Titanic"}, "Ship",
"Car"
)

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MyWeeLola 

 

The first method is to right click on the Attribute column and select New group. This feature can help you group values in this column through GUI easily and give you the group column you want. Use grouping and binning in Power BI Desktop - Power BI | Microsoft Learn

 

The second method is to use DAX to create a calculated column

Column = SWITCH(TRUE(),
'Table'[Attribute] IN {"Jet","Seaplane","Glider"}, "Plane",
'Table'[Attribute] IN {"Titanic"}, "Ship",
"Car"
)

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

  • MyWeeLola's avatar
    MyWeeLola
    Icon for Helper II rankHelper II
    2 years ago

    Anonymous 

    Perfect, thank you for this.

    Lola