Group Two Products

I'm just looking to combine/group Product A and F. This would then give me a new product with their combined values. Is this possible?

kylesmyle you need to add a new column and then use that on the row:

New Product Column = 
IF ( Table[Product] IN { "Product A", "Product F" }, "Product A & F", Table[Product] )

parry2k
Super User
3 years ago
kylesmyle glad it worked. Keep in mind it is always good to add a column (if possible) in PQ. FYI.
parry2k
Super User
3 years ago
kylesmyle you need to add a new column and then use that on the row:

New Product Column = IF ( Table[Product] IN { "Product A", "Product F" }, "Product A & F", Table[Product] )
- kylesmyle
  Frequent Visitor
  3 years ago
  parry2k It does not seem to work. Do you see where I'm wrong?
parry2k
Super User
3 years ago
kylesmyle oh! You are adding a column in the PQ, the solution I was provided was based on adding a calculated column using DAX. If you need an M code then do this:

if [Product] = "Product A" or [Product] = "Product F" then "Product A & F" else [Product]
- kylesmyle
  Frequent Visitor
  3 years ago
  I see what what meant before. That actually worked better using DAX. I am brand new to PBI so I didn't know the difference between DAX and PQ, but now I do, thanks!

Forum Discussion