Mixing of column data

[UditJ]

Hello , I have two columns as below:

Column1    Column2 
Online         Social
Offline         OTT
                    Radio
                     TV

Need to create a calcualkted Column as below

Calculated Column - Column 3 
Total Media (Online+Offline) 
Online

Offline
Social 

Any suggestions ?

[ryan_mayu]

do you want to combine the values under those categories? or just combine text?

the calculated column must have the same rows as the original data. could you pls provide the sample data and the expected output in the same table?

[UditJ]

Master Channel	Channel	Cost	year	SOS	SOM	abc	abc
online	Soical	56	2021
offline	radio	43	2022
	tv	12	2023

Above table is sample data and above that is the table i need to create in power bi. I need a column with Total Media , Online , offline and social.     

Total Media = Online +offline (from column master channel)
online from column master channel
Offline from column master channel
Social from column channel