Replicating Tableau Formula in Power BI

[UditJ]

Need to write the below formula in power bi:

If
[HVT FriendlyName]!= "Foot Traffic" AND
[HVT FriendlyName]!= "Exit to Tier 3" AND
([HVT FriendlyName]="Configuration" OR
[HVT FriendlyName]="Config Complete" OR
[HVT FriendlyName]= "Configuration Summary - Hybrid" OR
[HVT FriendlyName]="Find a Dealer" OR
[HVT FriendlyName]="Get Local Price Complete" OR
[HVT FriendlyName]="Request a Quote" OR
[HVT FriendlyName]="Offers" OR
[HVT FriendlyName]="Test Drive" OR
([Hvt Cpo]="Yes") )
Then [Conversions Combined] END

[BiNavPete]

Hi @UditJ 

Not familar with tableau but reckon you need a SWITCH TRUE Construct.
I'd have a go at writing it but not familiar with the tableau syntax here.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!

Pete
Web: https://binavigation.com
Linked In: https://www.linkedin.com/in/pete-smith-955b73181

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!

Pete
Web: https://binavigation.com
Linked In: https://www.linkedin.com/in/pete-smith-955b73181

[miTutorials]

Please see the below tutorial.

How to use AND & OR conditions within IF Statement in PowerBI | MiTutorials - YouTube