How to group the data of a table under the same name?

[Anonymous]

Good morning everyone,

I have the following problem. My data currently looks like this

Company  ||  Value 2018 ||  Value 2019  ||

      A                     20                  13

      B                     23                  45

      C                     15                  15

      D                      2                   10              

      E                      30                  35 

----------------------------------------------

  TOTAL                90                  118          

And I would like to group al the companies which aren't A, B or C under the name ''REST'' to create something like this:

Company  ||  Value 2018 ||  Value 2019  ||

      A                     20                  13

      B                     23                  45

      C                     15                  15

     REST                 32                  45

----------------------------------------------

  TOTAL                90                  118          

Any ideas? 

Thank you very much!

Regards

[Mariusz · Accepted solution]

Hi  @Anonymous 

You can add a column like below.

Column = 
VAR __col ='Table'[Column1]
RETURN 
IF( __col IN { "A", "B", "C" }, __col, "Rest" )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[Anonymous]

Lovely, that was exactly what I was looking for!

Regards

Adrian