Forum Discussion

KT9's avatar
KT9
Regular Visitor
2 years ago
Solved

DAX

Hi All,

I am new to the PowerBI. Using SQL Query as a base, I need to make calculated column using DAX.But having trouble to create DAX. plese help. Thanks in advance.

 

Rules for calculated column:

1. If Final = Negative, then Negative

2. If Final = positive AND type = ABCD, then display the associated value in numeric_result

3. IF Final = positive AND type = XYZ, then Positive

4. If Final = In Range, then In Range

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi KT9 ,

    Looks like you're trying to create a measure instead of a calculated column.  If you use the same exact code, but as a calculated column, you shouldn't have an issue.

     

    Or you can modify KT9 's formula.

    Result =
SWITCH(TRUE(),
YourTable[Final] = "Negative", "Negative",
YourTable[Final] = "Positive" && YourTable[Type] = "ABCD", max(YourTable[Numeric_Result]),
YourTable[Final] = "Positive" && YourTable[Type] = "XYZ", "Positive",
YourTable[Final] = "In Range", "In Range",
BLANK() 
)

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

3 Replies

  • ElliotG's avatar
    ElliotG
    Frequent Visitor
    2 years ago

    Try this

    Result =
    SWITCH(TRUE(),
    YourTable[Final] = "Negative", "Negative",
    YourTable[Final] = "Positive" && YourTable[Type] = "ABCD", YourTable[Numeric_Result],
    YourTable[Final] = "Positive" && YourTable[Type] = "XYZ", "Positive",
    YourTable[Final] = "In Range", "In Range",
    BLANK() 
    )

    • KT9's avatar
      KT9
      Regular Visitor
      2 years ago

      Hi ElliotG , 

      Thank you so much for your response. while importing the SQL data into power BI, I used import query option and wrote the sql query to filter the data and then i load it into the power BI. I tried to write the DAX formulae but it is thowing me this error. I have no idea. 

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi KT9 ,

        Looks like you're trying to create a measure instead of a calculated column.  If you use the same exact code, but as a calculated column, you shouldn't have an issue.

         

        Or you can modify KT9 's formula.

        Result =
SWITCH(TRUE(),
YourTable[Final] = "Negative", "Negative",
YourTable[Final] = "Positive" && YourTable[Type] = "ABCD", max(YourTable[Numeric_Result]),
YourTable[Final] = "Positive" && YourTable[Type] = "XYZ", "Positive",
YourTable[Final] = "In Range", "In Range",
BLANK() 
)

         

        How to Get Your Question Answered Quickly 

         

        If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

         

        Best Regards
        Community Support Team _ Rongtie

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.