Forum Discussion
Solved
Create new column from data within column
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
DavidGM , Create a measure like and try
calculate(Sum(Table[IT Fun plan]), filter(Table, Table[IT Fund source] <> " SG&A Funding"))
1 Reply
DavidGM , Create a measure like and try
calculate(Sum(Table[IT Fun plan]), filter(Table, Table[IT Fund source] <> " SG&A Funding"))