Forum Discussion
Group By Formula
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)
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
1 Reply
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