kylesmyleFrequent Visitor3 years agoSolvedGroup 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? Show Moreparry2k3 years agokylesmyle 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] )
parry2k3 years agokylesmyle 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] )
parry2k3 years agokylesmyle 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] )
parry2kSuper User3 years agokylesmyle glad it worked. Keep in mind it is always good to add a column (if possible) in PQ. FYI.
Related contentFabric & Azure Data User Group Program Requirements & BenefitsCommunity User Group ExperienceProduction LessonsCreating DAX formula for group of productsUser Group Leader Get Started Guide
