DAX

[KT9]

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

[ElliotG]

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]

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 · Accepted solution]

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.