Create Calculated Column for new security trades which shows either current holdings, buys, sells

[OldN00b]

Hi Guys - newbie here, i am trying to add a column which identifies new trades between two dates (current week and prior week) with the goal to calculate the total value of new trades , sells, and existing holdings. 

My data set looks something like this (Type of Holding is what I want the calculated column to look like)

Link to sample dataset: https://docs.google.com/spreadsheets/d/e/2PACX-1vQQCHpm7AAomMcuPlExXjY3tYnj7WzLkiZXfPUvL6FHtzMUc-unt...

I would like to use this column to track the changes in face value using a decomposition tree (something similar to the below example).

[daXtreme]

"i am trying to add a column which identifies new trades between two dates"

Yeah... we'd like to be able to identify them as well but we don't know the rule that does it.

[amitchandak]

@OldN00b , Logic is not very clear . But Rank on Position date and earlier will help

Rank = Rankx(Table, Table[Position date],,asc, dense)

Last week same stock = sumx(filter(Table,[Position] = earlier([Position ID] ) && [Rank] = earlier([Rank]) -1) , [Original face value])

Next week same stock = sumx(filter(Table,[Position] = earlier([Position ID] ) && [Rank] = earlier([Rank]) +1) , [Original face value])

These three columns can help you

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.