Forum Discussion

etwa702's avatar
etwa702
Frequent Visitor
6 years ago
Solved

Comapring Number Values from same column with text values from same column

Hi all BIHelp  Greg_Deckler    I need some help please.   Some background for context.   - We are running a project for a in house web app we have created. The Web app consists of multiple tr...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    See above

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi etwa702 ,

OK, created a new measure "...Revised" That wrapped "Winning Build with an if statement. So just compare the two and make the change.  You could if you wish define the granularity even more, and add another if to determine whether it is "Sept Test not performed."

 

Glad I could help!

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

Winning Build Revised = IF( ISBLANK([Sep Final]) || ISBLANK([Oct Final]),"Test not Performed", IF([Oct Final]>[Sep Final], "Oct Final" , If([Sep Final]>[Oct Final],"Sept Final","SAME Result")))

 

 

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Tested on page 2