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

kcantor's avatar
kcantor
Community Champion
9 years ago

nmck86

Can you share with us the measure you are using?

  • nmck86's avatar
    nmck86
    Post Patron
    9 years ago

    Investment Priority Test = IF('CyberGrants Data'[Proposal Type] = "Internal Proposal", 'CyberGrants Data'[Select the applicable investment priority ], IF('CyberGrants Data'[Select the applicable investment priority ] = Blank(), 'CyberGrants Data'[Corporate Focus Area]))

     

    This is something similar to what I have... However, when I was running it only select applicable investment priority would pull back.. none of the other conditions if that field is blank are working... I hope this helps... 

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