Create new column from data within column

[DavidGM]

 Hi, I like to remove SG&A Funding from IT Funding source column and create new column for SG&A Funding with its value? 

I can filter IT Funding to not show SG&A, but how will I create a new column shoeing SG&A. Thanks 

[amitchandak · Accepted solution]

@DavidGM , Create a measure like and try

calculate(Sum(Table[IT Fun plan]), filter(Table, Table[IT Fund source] <>  " SG&A Funding"))