Forum Discussion

e77948's avatar
e77948
Regular Visitor
4 years ago
Solved

How do I write an IF then formula

I have a table and I need to show the data depending upon one column, I am trying to write a measure that will show the number of work items if that colu
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi e77948 ,

     

    In Power Query, it's like this:

    if somethingIsTrue
then doThis
else if somethingElseIsTrue
then doThisThingInstead
else doThisThing

     

    In DAX, it's like this:

    IF(
    somethingIsTrue,
    doThis,
    doThisThingInstead
)

     

    Pete

  • BA_Pete's avatar
    BA_Pete
    4 years ago

     

    Ah, ok, my bad. Text functions don't skip blanks.

    Try this one:

    if [Tags] = null then "Primary"
else if Text.Contains([Tags], "Secondary") then "Secondary"
else "Primary"

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi e77948 ,

 

'isBlank' isn't an M language function, it's a DAX function.

If you can describe the behaviour that you're trying to achieve, I can write the correct M code syntax for you.

 

Pete

e77948's avatar
e77948
Regular Visitor
4 years ago

I want the custom column to say "Primary" if the column "Tags", does not contain the word "Secondary",  or if the "Tags" column is blank, and I want the new column to say "Secondary" if the "Tags" column, contains the word "Secondary".

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

     

    Cool. Try this in a new custom column:

    if Text.Contains([Tags], "Secondary") then "Secondary" else "Primary"

     

    Based on your requirement, we don't need to specify anyhting for a blank [Tags] value, as we just pass anything that doesn't contain "Secondary" as a "Primary" output.

     

    Pete

    • e77948's avatar
      e77948
      Regular Visitor
      4 years ago

      I get errors for the 25 rows that are blank when I use that query, 

      • BA_Pete's avatar
        BA_Pete
        Super User
        4 years ago

         

        Ah, ok, my bad. Text functions don't skip blanks.

        Try this one:

        if [Tags] = null then "Primary"
else if Text.Contains([Tags], "Secondary") then "Secondary"
else "Primary"

         

        Pete