Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 user.
My thought was to create a calculated column that would apply my "grouped" titles to the attributes, however, I'm struggling to get the code I need.
In my example, I want the calculated column to apply, "Car, Plane, Ship" to the relevant attribute
I was thinking
Vehicle =
union(
addcolumns(
//goes wrong here
'mytable',"Type",'mytable'[attribute] = "Dodge","Car"),
//other selections
Dax is telling me that I have messed up with no scalar expression certified.
I think I'm trying to return the complete table, however I'm unsure how to this without "if then" statements
as a second question, in the example, if I specified which are ships and planes, could I make a default selection which makes the rest "cars"?
I look forward to hearing back.
Lola
Solved! Go to Solution.
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!
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |