Move specific rows from one column to another column

[lennox25]

Hi , 

I have a column 'Subject' that contains the title of the email received. I need to filter out and move to another column. Any 'Accepted', 'Tentative', 'Automatic reply'. What would be remaining would be considered non junk emails which I want to focus on. 

Can anyone help? TIA

[SpartaBI]

@lennox25 you want to create a calculated column that will give the same result of the subjuct in case the condition is met and will be blank otherwisw?
What are the names of your table and columns so I could write to you the exact function.

[lennox25]

To add - I do need to know how many accepted, tentative etc there are so will need a column with those in 🙂

[SpartaBI]

@lennox25 what is the name of the column that has these values?
'Accepted', 'Tentative', 'Automatic reply'

[SpartaBI · Accepted solution]

@lennox25 so you can add this calculated column:

Column = 
IF(
    SWITCH(
        TRUE,
        CONTAINSSTRING(CMailbox[Subject], "Accepted"), TRUE(),
        CONTAINSSTRING(CMailbox[Subject], "TentatiVe"), TRUE(),
        CONTAINSSTRING(CMailbox[Subject], "Automatic reply"), TRUE(),
        FALSE()
    ),
    CMailbox[Subject]
)

      

Showcase Report – Contoso By SpartaBI

[lennox25]

Hi -Thank you - That has worked perfectly! Is there a way to remove these Accepted etc from the Subject Column?

[SpartaBI]

@lennox25 wdym? can you give me an example of the outpot?
P.S. please don't forget to accept the previous message as a solution and will appreciate your Kudos on my messages 😀😉

[lennox25]

Hi - Thank you - I will accept as solution  - so the snippet I posted earlier. What I need  is to be able to filter out the 'junk' emails but also report on them. Essentially when all of these 'acceptance, decline, tentative etc. are taken off then only the emails that do not come under these subjects will be left. The calculated column you created for me filters all these out but I also need to have them under headings so my report should have columns: Subject, Acceptance, Decline, Tentative, Auto acceptance (all the junk that has been filtered out to another column)

[SpartaBI]

@lennox25 I will PM you know

[SpartaBI]

@lennox25 I pm you 50 minutes ago 🙂 Got your Kudos, so maybe you didn't see my message.

[SpartaBI]

@lennox25 hey, adding a link to download the file. Let me know if that is what you meant or you need somethig else.
Move specific rows from one column to another column.pbix

      

Showcase Report – Contoso By SpartaBI

[lennox25]

Hi - Thank you! My table is called CMailbox.  My column that I want to seperate is called Subject

[SpartaBI]

@lennox25 what is the name of the column that has these values?
'Accepted', 'Tentative', 'Automatic reply'

[lennox25]

[lennox25]

Hi - they all come under 'subject' so I have - accepted, automatic reply, tentatives and then all other emails to action - ie. RE - Map of UK, RE: Away day September.