Forum Discussion

nmck86's avatar
nmck86
Post Patron
9 years ago
Solved

Dax Formula Help

Hi All,   I am working with a dataset similar to the one listed below and I am trying to create a DAX formula and have been using an IF formula and it was a formula that looked at the Proposal Type...
Need Help
Show and Tell
Tips and Tricks
  • Sean's avatar
    Sean
    9 years ago

    Can you elaborate why you think its ignoring the second half?

    Investment Priority Test =
IF (
    'CyberGrants Data'[Proposal Type] = "Internal Proposal -Administrators Only",
    IF (
        'CyberGrants Data'[Select the applicable investment priority ] = BLANK (),
        'CyberGrants Data'[Corporate Focus Area],
        'CyberGrants Data'[Select the applicable investment priority ]
    ),
    IF (
        'CyberGrants Data'[Proposal Type] = "Local Community Development",
        'CyberGrants Data'[Investment Priority Category ],
        'CyberGrants Data'[Proposal Type]
    )
)

    Seems to work fine

     

    Make sure you are checking for the correct column values - meaning the conditions are spelled as they are in the column

    "Internal Proposal " will not be found in the Proposal Type Column but "Internal Proposal" will be with no space at the end

nmck86's avatar
nmck86
Post Patron
9 years ago

Hi I am still working to understand switch statements... does anyone know why my formula below is IGNORING the 2nd half of my if statement around "Local Community Development" that is the issue I am running into now... I have an if statement that is working but there seems to be something wrong with my logic since it is diregarding the second half of the formula.

 

Investment Priority Test = IF('CyberGrants Data'[Proposal Type] = "Internal Proposal -Administrators Only",
    IF('CyberGrants Data'[Select the applicable investment priority ] = BLANK(),  
        'CyberGrants Data'[Corporate Focus Area],'CyberGrants Data'[Select the applicable investment priority ]),
        IF('CyberGrants Data'[Proposal Type] = "Local Community Development",
            'CyberGrants Data'[Investment Priority Category ],'CyberGrants Data'[Proposal Type]))

Sean's avatar
Sean
Community Champion
9 years ago

Can you elaborate why you think its ignoring the second half?

Investment Priority Test =
IF (
    'CyberGrants Data'[Proposal Type] = "Internal Proposal -Administrators Only",
    IF (
        'CyberGrants Data'[Select the applicable investment priority ] = BLANK (),
        'CyberGrants Data'[Corporate Focus Area],
        'CyberGrants Data'[Select the applicable investment priority ]
    ),
    IF (
        'CyberGrants Data'[Proposal Type] = "Local Community Development",
        'CyberGrants Data'[Investment Priority Category ],
        'CyberGrants Data'[Proposal Type]
    )
)

Seems to work fine

 

Make sure you are checking for the correct column values - meaning the conditions are spelled as they are in the column

"Internal Proposal " will not be found in the Proposal Type Column but "Internal Proposal" will be with no space at the end

  • nmck86's avatar
    nmck86
    Post Patron
    9 years ago

    Ugh. You have to love pesky little "extra spaces" I wracked my brain on it and that was the issue and your reminder is what prompted me to verify it again :-)! Thanks so much!