i want to divide this by each other to give the % but i have been finding it difficulti want to divide this by each other to give the % but i have been finding it difficult

Anonymous , In query editor, create an index from 1, then create a calculate column using dax below: Result = VAR Current_Index = 'Table'[Index] VAR Current_Value = 'Table'[value] RETURN IF(MOD(Current_Index, 2) <> 0, Current_Value / CALCULATE(MAX('Table'[value]), FILTER('Table', 'Table'[Index] = Current_Index + 1))) Community Support Team _ Jimmy Tao If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.