Need help creating new column
Share adjustment price = VAR _INDEX = MAX('Investment'[Index]) VAR _INDEX_1 = _INDEX - 1 VAR a = SUMX('Investment', 'Investment'[Qty]) VAR b = SUMX('Investment', 'Investment'[Price]) VAR c = [Closing Share] VAR d = CALCULATE ( [Closing Share], 'Investment'[Index] = _INDEX_1 ) VAR e = (b * a) / c RETURN RETURN SWITCH( TRUE(), 'Investment', 'Investment'[Transaction Type] = "Shares Adjustment", e, 0 )
