Forum Discussion

drrai66's avatar
drrai66
Resolver I
8 years ago
Solved

Need Help on This Formula

Hello Experts, I need to convert This Tableau Logic to Power BI, But I am Stuck. Not getting it to work. Please Help   IF [Status]="TRUE" THEN IF CONTAINS(Languages,".net") OR CONTAINS(Languag...
Need Help
  • drrai66's avatar
    drrai66
    8 years ago

    Thanks Phil and Ashish, I got it Working . This is My Actual Calculation and It is working Perfectly. Thank you Guys for Support.

    Thanks

    Deepak

    Here is Formula I used

     

    IF('Merged Project Data'[Java Script Check 1]>0,IF(ISERROR(SEARCH("Java,",'Merged Project Data'[Language])) && ISERROR(SEARCH(".net",'Merged Project Data'[Language]))&& ISERROR(SEARCH(".NET",'Merged Project Data'[Language]))&& ISERROR(SEARCH("C#",'Merged Project Data'[Language]))&& ISERROR(SEARCH("Microsoft.Net",'Merged Project Data'[Language]))  && ISERROR(SEARCH("Objective-C",'Merged Project Data'[Language]))&& ISERROR(SEARCH("Python",'Merged Project Data'[Language]))&& ISERROR(SEARCH("Ruby",'Merged Project Data'[Language]))&& ISERROR(SEARCH("Siebel",'Merged Project Data'[Language]))&& ISERROR(SEARCH("Proc",'Merged Project Data'[Language]))&& ISERROR(SEARCH("J2EE",'Merged Project Data'[Language])) ,0,'Merged Project Data'[Apps With Platform]))

drrai66's avatar
drrai66
Resolver I
8 years ago

I Think this should be OK. In my actually data, I have 16 OR Statements, so tomorrow I would apply, verify and come back to you with good news.

Thanks a lot

Deepak

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

In that instance, I would probably put all your search terms into a table on their own and re-write the calculation to join to the reference table..