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.
Hello guys, do you have any idea how to easily add a fixed increment? The only thing I can think of is the if function, but I have several thousand rows and would prefer to streamline it 🙂 Simple data:
x | y |
1255 | 1 |
2545 | 0,99 |
3555 | 0,98 |
4787 | 0,97 |
6222 | 0,95 |
6565 | 0,95 |
8855 | 0,93 |
9001 | 0,91 |
9655 | 0,91 |
I would like the function, after x increases by 1000, to subtract 0.01 from y. This can be as a new column or function, of your choice.
Solved! Go to Solution.
hi @Pan_Forex
then try this:
please consider @ someone, if you seek further suggestions.
Because the range is between 0-1000, 1001-2000, in the second example there is an error. let's make it simple. For numbers < 1000-1, between 1001-2000=0,99, between 2001-3000=0,98 and so on
hi @Pan_Forex
then try this:
please consider @ someone, if you seek further suggestions.
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
73 | |
50 | |
45 | |
20 | |
17 |