Forum Discussion
Create Historical Stock
Hi,
Share the download link of the PBI file. Ensure that in the Stock Table, there is a Date column.
Stock Table
Let's say today is 2024-01-02
Product Quantity
A 100
B 50
Shipment Table
Product Shipped Date Quantity
A 2024-01-01 10
A 2023-12-31 10
B 2023-12-30 10
Input Stock Table
Product Shipped Date Quantity
A 2024-01-01 30
B 2023-12-31 40
In this case, I want to make a line graph that shows entire stock and of course it should be filtered by product.
If I show expected value by table,
Product Date Stock Quantity
A 2024-01-02 100 Current Stock
B 2024-01-02 50 Current Stock
A 2024-01-01 100 After 10 Shipped, 30 input
B 2024-01-01 50 No transaction, no input
A 2023-12-31 80 After 10 Shipped
B 2024-12-31 50 After 40 Shipped
A 2023-12-30 90 No transaction, no input
B 2024-12-30 10 After 10 input
Based on this stock in the graph should be...
In case Daily Stock, it should show sum of each product stock.
In case Monthly Stock, it should show sum of each product stock at the last day of a month.
It is very complicated...
Hi,
I just cannot understand how you arrived at the number in the third table. Put all information in an MS Excel file and calculate the numbers shown the Balance column of the third table via Excel formulas. I will try to convert those Excel formulas to DAX formulas.