Replicate Formula from Tableau to Power BI

[UditJ]

need to replicate below formula in Power BI 

IF (contains([Site Name],'facebook')
OR contains([Site Name],'FACEBOOK')
OR contains([Site Name],'linkedin')
OR contains([Site Name],'snapchat')
OR [Site Name]='PINTEREST'
OR [Site Name]='TWITTER'
OR [Site Name]='REDDIT.COM')
THEN
'Social'
ELSE
[Media Channel]
END

any suggestions ?

[miTutorials]

Go to Power Query, Under ADD COLUMN Tab click on CUSTOM COLUMN.

Paste the below code.

if List.Contains({"Facebook","Twitter","Linkedin"},[ENTER YOUR COLUMN NAME]) then "SOCIAL" else ""

Regards

Ismail

www.Youtube.com/MiTutorials