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.
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.
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
21 | |
14 | |
14 | |
9 | |
7 |