Forum Discussion

JMWDBA's avatar
JMWDBA
Icon for Advocate II rankAdvocate II
9 years ago
Solved

True and False with unrelated fields

So I know how to use the True and False clause when the values between two fields are equal and when they are not equal but I am unsure if its possible to use the True/False by validating parameters ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi JMWDBA,

     

    A little weird. The formula should work. Could you try the formula below to see if it works? :smileyhappy:

    Military Rate =
IF (
    'Registrations'[Term Military Civilian Type Descr] = "Civilian"
        && (
            ISBLANK ( 'Registrations'[Term Military Status] )
                || 'Registrations'[Term Military Status] = ""
        ),
    "No Military Rate",
    "Military Rate"
)

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi JMWDBA,

 

A little weird. The formula should work. Could you try the formula below to see if it works? :smileyhappy:

Military Rate =
IF (
    'Registrations'[Term Military Civilian Type Descr] = "Civilian"
        && (
            ISBLANK ( 'Registrations'[Term Military Status] )
                || 'Registrations'[Term Military Status] = ""
        ),
    "No Military Rate",
    "Military Rate"
)

 

Regards

JMWDBA's avatar
JMWDBA
Icon for Advocate II rankAdvocate II
9 years ago

That worked like a charm!!! You are heaven-sent!!!:smileylol: