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

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!