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.
Hello All,
Being new to Power BI, I'm unsure how to go about finding this solution. I've included a screenshot of what I've done in Excel, but would like to do in Power BI.
Below is a Pivot of a table sorted by Posting Date and Amount in LC. The column Inventory Movement was added by me. What I've done to populate Inventory Movement is take the SUM of a column titled "Value Unrestricted" and added the amount starting from the most recent date. $253k + $8.5k = $261k + -$1.2k = $260k and so on as shown below. Going forward, I just want to capture the most recent date and add Amount in LC to the sum of Value Unrestricted in descending dates.
Thanks in advance for the help!
Solved! Go to Solution.
Hi @fluffyhead,
You can try to use following measure to get previous amount to calculate value unrestricted.
Value Unrestricted =
VAR _current =
SELECTEDVALUE ( table[Inventory Movement] )
VAR _currentDate =
MAX ( table[post date] )
VAR _previous =
MAXX ( FILTER ( ALL ( table ), [post date] < _currentDate ), [post date] )
RETURN
_current
+ CALCULATE ( SUM ( table[Amount in LC] ), table[post date] = _previous )
Regards,
Xiaoxin Sheng
Hi @fluffyhead,
You can try to use following measure to get previous amount to calculate value unrestricted.
Value Unrestricted =
VAR _current =
SELECTEDVALUE ( table[Inventory Movement] )
VAR _currentDate =
MAX ( table[post date] )
VAR _previous =
MAXX ( FILTER ( ALL ( table ), [post date] < _currentDate ), [post date] )
RETURN
_current
+ CALCULATE ( SUM ( table[Amount in LC] ), table[post date] = _previous )
Regards,
Xiaoxin Sheng
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 |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |