Calculated column using data from multiple rows and columns

Here is one way to approach this in a calculated column.  Please try this expression.

Result =
VAR index1 =
    CALCULATE (
        MIN ( Frame[Value] ),
        ALLEXCEPT ( Frame, Frame[FrameID], Frame[Date] ),
        Frame[SubIndex] = 1
    )
VAR index5 =
    CALCULATE (
        MIN ( Frame[Value] ),
        ALLEXCEPT ( Frame, Frame[FrameID], Frame[Date] ),
        Frame[SubIndex] = 5
    )
VAR index6 =
    CALCULATE (
        MIN ( Frame[Value] ),
        ALLEXCEPT ( Frame, Frame[FrameID], Frame[Date] ),
        Frame[SubIndex] = 6
    )
RETURN
    IF ( NOT ( ISBLANK ( index6 ) ), 100 * DIVIDE ( index5, index1 ) / index6 )

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Hi,

This calculated column formula works

=DIVIDE(DIVIDE(100*CALCULATE(SUM(Data[Value]),FILTER(Data,Data[FrameID]=EARLIER(Data[FrameID])&&Data[Date]=EARLIER(Data[Date])&&Data[SubIndex]=5)),CALCULATE(SUM(Data[Value]),FILTER(Data,Data[FrameID]=EARLIER(Data[FrameID])&&Data[Date]=EARLIER(Data[Date])&&Data[SubIndex]=1))),CALCULATE(SUM(Data[Value]),FILTER(Data,Data[FrameID]=EARLIER(Data[FrameID])&&Data[Date]=EARLIER(Data[Date])&&Data[SubIndex]=6)))

Hope this helps.