Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi community,
Have this thing to fix: I have a column of decimal values and I would like this to happen:
235,24 > 235
207.24 > 209
159.45 > 159
371.80 > 375
343.92 >345
in other words, adjusted numbers always have to finish in 5 or 9.
I tried with INT or round Up but doesn't always work.
Do you know any other way?
thank you
Alberto
Solved! Go to Solution.
HI @Anonymous
I think I follow what you need and I think this calculated column gets close. You can tweak the IN statement to control if you prefer Zeros to round to 5 or 9. I have attached a PBIX file
Column = VAR BaseVar = INT('Table1'[Column1]) VAR NewEndVal = SWITCH(TRUE(),MOD(BaseVar,10) IN {0,1,2,3,4,5} , 5 , 9) RETURN (INT(DIVIDE(BaseVar,10)) * 10) + NewEndVal
HI @Anonymous
I think I follow what you need and I think this calculated column gets close. You can tweak the IN statement to control if you prefer Zeros to round to 5 or 9. I have attached a PBIX file
Column = VAR BaseVar = INT('Table1'[Column1]) VAR NewEndVal = SWITCH(TRUE(),MOD(BaseVar,10) IN {0,1,2,3,4,5} , 5 , 9) RETURN (INT(DIVIDE(BaseVar,10)) * 10) + NewEndVal
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |