Forum Discussion

finance_124's avatar
finance_124
New Member
4 years ago

Dax Code to identify Outliers

Long time reader, first time poster...   I'm having a difficult time figuring out the DAX formula to identify outliers. I can easily do this in Excel but just can't figure out the needed DAX code. ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi finance_124 

you can create new column 

IF ( Table[Minutes] > Table[Upper Bound], "Outlier", "Normal" )

  • finance_124's avatar
    finance_124
    New Member
    4 years ago

    Thanks tamerj1. I thought it was as easy as that but it's showing them all as normal.

    FYI..I've inherited this existing Power BI dashboard and they want some enhancements to it.

     

    Now, would it be because a measure was created for Avg, 25th Percentile, 75th Percentile, IQR, Lower Bound, and UpperBound versus creating a new column for those? There are also some filters that the user could apply on the front page(Account and Date), I've included those two fields to show what they could filter on. Is there a way to do an outlier formula in a measure?

     

    Please note: All yellow columns are Measures.