The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
Hi!
You can create a calculated column like this:
Calc column = IF([Monthly Income] > 1000000, 150000, [Monthly Income])
Hi!
You can create a calculated column like this:
Calc column = IF([Monthly Income] > 1000000, 150000, [Monthly Income])
Thank you so much
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |