Group By Formula

[Anonymous]

Hi,

I have a column 1 with all my costumers and I have other column 2 where I categorize them as "G" and "O" what I want is a new column 3 where I have all the costumers O by name and all the customers that belong to G, only have a G insted of the costumer name

Example column 3

Customer 1 (all the customers that are in category O will appear with the name as column 1)

Customer S

Customer 45

Customer AB

G (all the customers that are in this category will appear with a G instead of the name as column 2)

[Thejeswar · Accepted solution]

Hi @Anonymous ,

Create either a Calculated Column. The Below is how the DAX will look

Column3 = IF(Column2 = "G", Column2, Column1)

If you want more clarity refer the below link

IF function (DAX) - DAX | Microsoft Learn

If you share some sample data and expected output, the DAX can be more focused