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

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