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.
Dear friends,
How can I refer to the previous row in Power BI this way?
Thank you
Solved! Go to Solution.
If doing in DAX Calculated column, something like below.
Column = VAR calc = CALCULATE ( MAX ( [Amount] ), FILTER ( Table, [Index] = ( EARLIER ( [Index] ) - 1 ) ) ) * ( 1 + CALCULATE ( MAX ( [Rate] ), FILTER ( Table, [Index] = ( EARLIER ( [Index] ) - 1 ) ) ) ) RETURN IF ( ISBLANK ( calc ), 1000, calc )
If doing in DAX Calculated column, something like below.
Column = VAR calc = CALCULATE ( MAX ( [Amount] ), FILTER ( Table, [Index] = ( EARLIER ( [Index] ) - 1 ) ) ) * ( 1 + CALCULATE ( MAX ( [Rate] ), FILTER ( Table, [Index] = ( EARLIER ( [Index] ) - 1 ) ) ) ) RETURN IF ( ISBLANK ( calc ), 1000, calc )
Hi @Chihiro,
Thank you for your answer. Is it possible to write the formula inside "Amount" column in DAX?
Can't think of way to do it in DAX.
Let me think on it.
Depends on where you want to do the calculation.
In Query Editor ("M"): Replace #"PreviousStep" with acutal previous step name
= try #"PreviousStep"{[Index]-2}[Amount] * (1 + #"PreviousStep"{[Index]-2}[Rate]) otherwise 1000
Since row index is 0 based, and your index column is 1 based, you'd subtract 2 from index column value to obtain row index of previous row.
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |