Forum Discussion
UditJ
Helper III
Helper IIIReplicate Formula from Tableau to Power BI
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 ?
1 Reply
miTutorialsSuper User
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