Forum Discussion
Solved
Use previous row in current column calculation
Hello, trying to create a calculated column using data from the previous row. See example below for situation which has been calculated in excel for Indexation Factor. Indexation factor formu...
Hi mellon199
Here is a sample file with the solution https://we.tl/t-KyxjUgcvAiFor a caclulated column:
Indexation Factor = VAR T1 = FILTER ( Data, Data[Index] <= EARLIER ( Data[Index] ) ) RETURN PRODUCTX ( T1, 1 + Data[Selected Index] )For a measure:
Indexation Factor Measure = VAR SelectedIndex = SELECTEDVALUE ( Data[Index] ) VAR T1 = CALCULATETABLE ( Data, Data[Index] <= SelectedIndex, ALL ( Data[Selected Index] ) ) RETURN PRODUCTX ( T1, 1 + Data[Selected Index] )
tamerj1
Community Champion
Community ChampionHi mellon199
Here is a sample file with the solution https://we.tl/t-KyxjUgcvAi
For a caclulated column:
Indexation Factor =
VAR T1 =
FILTER (
Data,
Data[Index] <= EARLIER ( Data[Index] )
)
RETURN
PRODUCTX (
T1,
1 + Data[Selected Index]
)
For a measure:
Indexation Factor Measure =
VAR SelectedIndex =
SELECTEDVALUE ( Data[Index] )
VAR T1 =
CALCULATETABLE (
Data,
Data[Index] <= SelectedIndex,
ALL ( Data[Selected Index] )
)
RETURN
PRODUCTX (
T1,
1 + Data[Selected Index]
)
