Forum Discussion
Helper IIIReplicating Tableau Formula in Power BI
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
2 Replies
miTutorialsSuper User
Please see the below tutorial.
How to use AND & OR conditions within IF Statement in PowerBI | MiTutorials - YouTube
- BiNavPete
Resolver III
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-955b73181Did 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
