Please help for stock problem

Question

Hello everyone,I have given the following table. When I sort the table by date in Power BI, this comes up. The order is absolutely correct and is exactly what it is supposed to be.I created the custom index with Power query&nbsp;&nbsp;&nbsp;&nbsp;current situation:ID&nbsp;ProductID&nbsp;Nr&nbsp;Date&nbsp;Quantity&nbsp;Art&nbsp;Input&nbsp;Output&nbsp;Stock&nbsp;accumulated Stock&nbsp;IndexCustomer&nbsp;123&nbsp;123&nbsp;1&nbsp;26.04.2022 00:00:00&nbsp;1&nbsp;Output&nbsp;0&nbsp;1&nbsp;-1&nbsp;75&nbsp;1281L&nbsp;123&nbsp;123&nbsp;1&nbsp;26.04.2022 00:00:00&nbsp;2&nbsp;Output&nbsp;0&nbsp;2&nbsp;-2&nbsp;73&nbsp;1282M&nbsp;123&nbsp;123&nbsp;1&nbsp;27.04.2022 00:00:00&nbsp;2&nbsp;Output&nbsp;0&nbsp;2&nbsp;-2&nbsp;311&nbsp;1284N&nbsp;123&nbsp;123&nbsp;1&nbsp;27.04.2022 00:00:00&nbsp;2&nbsp;Output&nbsp;0&nbsp;2&nbsp;-2&nbsp;305&nbsp;1286O&nbsp;123&nbsp;123&nbsp;1&nbsp;27.04.2022 00:00:00&nbsp;2&nbsp;Output&nbsp;0&nbsp;2&nbsp;-2&nbsp;303&nbsp;1287P&nbsp;1084807&nbsp;123&nbsp;1&nbsp;27.04.2022 00:00:00&nbsp;4&nbsp;Output&nbsp;0&nbsp;4&nbsp;-4&nbsp;307&nbsp;1285Q&nbsp;123&nbsp;123&nbsp;2&nbsp;27.04.2022 09:15:33&nbsp;100&nbsp;Input&nbsp;100&nbsp;0&nbsp;100&nbsp;313&nbsp;1283R&nbsp;123&nbsp;123&nbsp;1&nbsp;28.04.2022 00:00:00&nbsp;1&nbsp;Output&nbsp;0&nbsp;1&nbsp;-1&nbsp;301&nbsp;1289S&nbsp;123&nbsp;123&nbsp;1&nbsp;28.04.2022 00:00:00&nbsp;1&nbsp;Output&nbsp;0&nbsp;1&nbsp;-1&nbsp;302&nbsp;1288T&nbsp;123&nbsp;123&nbsp;1&nbsp;28.04.2022 00:00:00&nbsp;1&nbsp;Output&nbsp;0&nbsp;1&nbsp;-1&nbsp;300&nbsp;1290U&nbsp;123&nbsp;123&nbsp;1&nbsp;28.04.2022 00:00:00&nbsp;1&nbsp;Output&nbsp;0&nbsp;1&nbsp;-1&nbsp;299&nbsp;1291V&nbsp;expected situation:ID&nbsp;ProductID&nbsp;Nr&nbsp;Date&nbsp;Quantity&nbsp;Art&nbsp;Input&nbsp;Output&nbsp;Stock&nbsp;accumulated Stock&nbsp;IndexCustomer&nbsp;123&nbsp;123&nbsp;1&nbsp;26.04.2022 00:00:00&nbsp;1&nbsp;Output&nbsp;0&nbsp;1&nbsp;-1&nbsp;75&nbsp;1281L&nbsp;123&nbsp;123&nbsp;1&nbsp;26.04.2022 00:00:00&nbsp;2&nbsp;Output&nbsp;0&nbsp;2&nbsp;-2&nbsp;73&nbsp;1282M&nbsp;123&nbsp;123&nbsp;1&nbsp;27.04.2022 00:00:00&nbsp;2&nbsp;Output&nbsp;0&nbsp;2&nbsp;-2&nbsp;71&nbsp;1284N&nbsp;123&nbsp;123&nbsp;1&nbsp;27.04.2022 00:00:00&nbsp;2&nbsp;Output&nbsp;0&nbsp;2&nbsp;-2&nbsp;69&nbsp;1286O&nbsp;123&nbsp;123&nbsp;1&nbsp;27.04.2022 00:00:00&nbsp;2&nbsp;Output&nbsp;0&nbsp;2&nbsp;-2&nbsp;67&nbsp;1287P&nbsp;123&nbsp;123&nbsp;1&nbsp;27.04.2022 00:00:00&nbsp;4&nbsp;Output&nbsp;0&nbsp;4&nbsp;-4&nbsp;63&nbsp;1285Q&nbsp;123&nbsp;123&nbsp;2&nbsp;27.04.2022 09:15:33&nbsp;100&nbsp;Input&nbsp;100&nbsp;0&nbsp;100&nbsp;303&nbsp;1283R&nbsp;123&nbsp;123&nbsp;1&nbsp;28.04.2022 00:00:00&nbsp;1&nbsp;Output&nbsp;0&nbsp;1&nbsp;-1&nbsp;302&nbsp;1289S&nbsp;123&nbsp;123&nbsp;1&nbsp;28.04.2022 00:00:00&nbsp;1&nbsp;Output&nbsp;0&nbsp;1&nbsp;-1&nbsp;301&nbsp;1288T&nbsp;123&nbsp;123&nbsp;1&nbsp;28.04.2022 00:00:00&nbsp;1&nbsp;Output&nbsp;0&nbsp;1&nbsp;-1&nbsp;300&nbsp;1290U&nbsp;123&nbsp;123&nbsp;1&nbsp;28.04.2022 00:00:00&nbsp;1&nbsp;Output&nbsp;0&nbsp;1&nbsp;-1&nbsp;299&nbsp;1291V&nbsp;&nbsp;

v-yanjiang-msft · Accepted Answer

Hi&nbsp;azaterol&nbsp;,
Has your problem been solved? According to your snapshot, if you want to calculate the accumulated stock based on the date and ID, as you have create a index column seams based on date, you can simply create a measure:
Accumulated Stock =
SUMX (
    FILTER (
        ALL ( 'Table' ),
        'Table'[ID] = MAX ( 'Table'[ID] )
            &amp;&amp; 'Table'[Index] &lt;= MAX ( 'Table'[Index] )
    ),
    [Stock]
)

Best Regards,Community Support Team _ kalyj
If this post&nbsp;helps,&nbsp;then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Please help for stock problem

2 Replies

Related content

Inventory and Stock balance calculation

stock ageing

stock ageing

Logic problem?

Grouped Stock Ranking problem

ID	ProductID	Nr	Date	Quantity	Art	Input	Output	Stock	accumulated Stock	Index	Customer
123	123	1	26.04.2022 00:00:00	1	Output	0	1	-1	75	1281	L
123	123	1	26.04.2022 00:00:00	2	Output	0	2	-2	73	1282	M
123	123	1	27.04.2022 00:00:00	2	Output	0	2	-2	311	1284	N
123	123	1	27.04.2022 00:00:00	2	Output	0	2	-2	305	1286	O
123	123	1	27.04.2022 00:00:00	2	Output	0	2	-2	303	1287	P
1084807	123	1	27.04.2022 00:00:00	4	Output	0	4	-4	307	1285	Q
123	123	2	27.04.2022 09:15:33	100	Input	100	0	100	313	1283	R
123	123	1	28.04.2022 00:00:00	1	Output	0	1	-1	301	1289	S
123	123	1	28.04.2022 00:00:00	1	Output	0	1	-1	302	1288	T
123	123	1	28.04.2022 00:00:00	1	Output	0	1	-1	300	1290	U
123	123	1	28.04.2022 00:00:00	1	Output	0	1	-1	299	1291	V