cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mullotra Frequent Visitor
Frequent Visitor

Create new column based on other columns

Hello All,

 

I have data as below and neww to create a new column as below.

If the activity is OT need to add the year end and forecast if it is SU need the value from Forecast column.Thanks for help

ActivityYear EndForecastNew coulmn
OT12113
OT12113
OT044
OT044
OT055
OT066
OT077
SU899
SU101111
SU121313
1 ACCEPTED SOLUTION

Accepted Solutions
vimal_parmar Established Member
Established Member

Re: Create new column based on other columns

@mullotra 

Column = IF(Test[Activity]="SU",Test[Forecast],Test[Year End]+Test[Forecast])

View solution in original post

2 REPLIES 2
vimal_parmar Established Member
Established Member

Re: Create new column based on other columns

@mullotra 

Column = IF(Test[Activity]="SU",Test[Forecast],Test[Year End]+Test[Forecast])

View solution in original post

mullotra Frequent Visitor
Frequent Visitor

Re: Create new column based on other columns

Thanks

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)