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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi e77948 ,

 

Sorry for that the information you have provided is not making the problem clear to me.

 

Can you please share more details (your tables, your problems, the expected output) to help us clarify your scenario? Or try methods provided by BA_Pete .

 

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

 

Best Regards,
Eyelyn Qin

e77948's avatar
e77948
Regular Visitor
4 years ago
if Text.Contains([Tags], "Secondary") then "Secondary" else "Primary" or if isBlank([Tags], "Primary")
  • 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