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,
I'm having diffulty creating a calculated column that would add the Quantity from the current row value and the next row's value. Please see table below with expected result vs actual result:
Expected Result | Actual Result | ||
Index | Quantity | Qty + next row | Qty + next row |
1 | 14 | 21 | 14 |
2 | 7 | 21 | 14 |
3 | 14 | 24 | 14 |
4 | 10 | 46 | 14 |
5 | 36 | 40 | 14 |
6 | 4 | 4 | 14 |
7 | 0 | 10 | 14 |
8 | 10 | 20 | 14 |
9 | 10 | 25 | 14 |
10 | 15 | 54 | 14 |
11 | 39 | 42 | 14 |
12 | 3 | 269 | 14 |
13 | 266 | 433 | 14 |
14 | 167 | 167 | 14 |
This is my logic:
Solved! Go to Solution.
@JeanMariePBI Maybe:
row plus one column =
VAR __Index = [Index]
VAR __Quantity = [Quantity]
VAR __Quantity1 = MAXX(FILTER('Table',[Index] = __Index + 1),[Quantity])
RETURN
__Quantity + __Quantity1
@JeanMariePBI Maybe:
row plus one column =
VAR __Index = [Index]
VAR __Quantity = [Quantity]
VAR __Quantity1 = MAXX(FILTER('Table',[Index] = __Index + 1),[Quantity])
RETURN
__Quantity + __Quantity1
Thank you, Greg_Deckler!
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |