ChetanabMicrosoft Employee4 years agoSolvedGet previous row I have the below table with 3 columns ID, Index and TeamName. I am trying to create a new column for previous row. I tried below DAX but its only giving me partial result. Please help. Previous ro...Show Moresmpa014 years agoChetanab Column = MAXX(FILTER(t1,t1[Index]=EARLIER(t1[Index])-1),t1[TeamName])
smpa01Community Champion4 years agoChetanab Column = MAXX(FILTER(t1,t1[Index]=EARLIER(t1[Index])-1),t1[TeamName])
Related contentPrevious Row Cell multiplied with This Row CellPrevious Row Value Daxrow minus previous rowget value from Previous rowget value from previous row
