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]))

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi drrai66

 

This calculated column gets close

 

Column = 
    SWITCH(
        TRUE() ,
        'Table2'[Status] = "TRUE" && 
            (
                SEARCH(".net",'Table2'[Languages],1,0)>0 ||
                SEARCH("Java",'Table2'[Languages],1,0)>0
                ) , "True" ,
        "False"
    )
drrai66's avatar
drrai66
Resolver I
8 years ago

Sorry Phil,

The Solution Is not Working, It is Not Searching with in TRUE Values For The Languages we put in the Next Statement, It Is Just Returing TRUE for  Even Those Languages which we have not searched for. In The above Example, it should return TRUE only if Finds .net and Java in Language Column.

Thanks

Deepak