Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 cus...
  • Thejeswar's avatar
    3 years ago

    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