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.
true round
901 900
2876 3000
2120 2000
2531 3000
8339 8000
3023 3000
14099 10000
I try ROUND,ROUNDUP,ROUNDDOWN,but it can't work for each number
Solved! Go to Solution.
Works with your sample data 🙂
You can use this as calculated column
= VAR Digits = LEN ( [true] ) - 1 VAR second_digit = VALUE ( MID ( [true], 2, 1 ) ) >= 5 RETURN SWITCH ( TRUE (), second_digit, ROUNDUP ( [true], - Digits ), ROUNDDOWN ( [true], - Digits ) )
Works with your sample data 🙂
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |