Need help with DAX function to bring down all outliers to a single value

[Anonymous]

Hi Community, 

I am new powerbi user and I just wanted help with a dax formula that can help scale my outliers to a single value.

I am trying to scale down Monthly Income which sits with outliers greater than a $1M and I am trying to bring all the values that are greater than that down to $150k. 

Your assistance would be greatly appreciated

[technolog · Accepted solution]

Hi!

You can create a calculated column like this:

Calc column = IF([Monthly Income] > 1000000, 150000,  [Monthly Income])

[Anonymous]

Thank you so much