Need help creating new column

Hi praveenjujare ，

Pease try:

Column = 
IF(
    'Investment'[Transaction Type] = "Shares Adjustment",
    VAR PreviousRowPrice = CALCULATE(
        MAX('Investment'[Price]),
        FILTER(
            'Investment',
            'Investment'[Index] = EARLIER('Investment'[Index]) - 1
        )
    )
    VAR PreviousRowClosingShare = CALCULATE(
        MAX('Investment'[Closing Share]),
        FILTER(
            'Investment',
            'Investment'[Index] = EARLIER('Investment'[Index]) - 1
        )
    )
    RETURN
        (PreviousRowPrice * PreviousRowClosingShare) / 'Investment'[Closing Share],
    BLANK()
)

Best Regards,

Bof