Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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).
"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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |