Mixing of column data

Question

Hello , I have two columns as below:Column1&nbsp; &nbsp; Column2&nbsp;Online&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SocialOffline&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OTT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Radio&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TV&nbsp;Need to create a calcualkted Column as belowCalculated Column - Column 3&nbsp;Total Media (Online+Offline)&nbsp;OnlineOfflineSocial&nbsp;Any suggestions ?

ryan_mayu · Answer

do you want to combine the values under those categories? or just combine text?
&nbsp;
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 · Answer

Master ChannelChannelCostyearSOSSOMabcabconlineSoical562021&nbsp;&nbsp;&nbsp;&nbsp;offlineradio432022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;tv122023&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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.&nbsp; &nbsp; &nbsp;Total Media = Online +offline (from column master channel)online from column master channelOffline from column master channelSocial from column channel

Forum Discussion

Mixing of column data

2 Replies

Related content

How to expand column of mixed data

Cleaning data in column with names in mixed order and formatting

How to format date when mixed data in the same column

Slicer/Filter Mixed Data

columns with mixed data types

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