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...
miTutorials
Super User
Super UserGo 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