Replace value

mithiladas02 , A new column in power query

if [Source Category] = "Job Boards" and [Source]="Linkdln" then [Source Category] & "-" & [Source] else [Source Category]

Hi mithiladas02 ,

Try something as follows in Power Query editor in Power BI.

This is the data:

Now under Add Column:

 Then a new window appears:

Formula that I have written can be seen below in editor window:

if 
   ([Source Category] = "JOb boards" 
   and [Source] = "Linkdln") 
   then "Job Boards-Linkdln" 
   else [Source]

You will get following:

Just remove the Source column:

Modify data-type of New Source to text and rename it to Source. You will get required results:

Thanks,

Pragati