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 colum...
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.

     

     

     

     

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.