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.
I'm not certain this is even possible, or within the realms of PowerBI; but I know this is the right place to ask!
I have a stock movements table that looks like this:
It has various types of stock movements from Stocktakes, through to Deliveries and Sales, Etc..... Every Stock Movement creates a stock line, and the running total is written to the line at that time.
Our users would like to select a specific Date / Time, and have the system return the total value of stock on hand based on their input. I have deduced that the following logic would give the correct result:
Based on the above, and a user input parameter of: 09/03/2021 22:00; I would expect the resultant table to look like this::
I'm fairly new to PowerBI, so have a few questions:
Regards
Robbie
@Robbief , Create measure like below example , for running total, value , movement type. If needed, then for date too.
Use an independent data table , if possible for filter
running total =
var __MAX = maxx(allselected(Date), Date[Date])
VAR __id = MAX ('Table'[ITEM] )
VAR __date = CALCULATE ( MAX('Table'[Date] ), ALLSELECTED ('Table' ), 'Table'[ITEM] = __id,'Table'[Date] <= __MAX )
CALCULATE ( Sum ('Table'[running total] ), VALUES ('Table'[ITEM] ),'Table'[ITEM] = __id,'Table'[Date] = __date,'Table'[Date] <= __MAX )
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |