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 need the answer needed like if A1 is one of the catagory material have totally 5 stocks and we needed two so atlast of A1 needed it's 3 like ... D2= C2-B2 ,,, D3= D2-B3...
D4 = C4-B4 ,,, D5=D4 -B5
Help me to find this column...
Solved! Go to Solution.
Hi, @ILANGO_10
You can try the following methods. You need to add an index column to Power Query first.
Column:
Cumulative quantity =
CALCULATE ( SUM ( 'Table'[quantity] ),
FILTER ( 'Table' ,
[material] = EARLIER ( 'Table'[material] )
&& [Index] <= EARLIER ( 'Table'[Index] )
)
)
Result = [stock]-[Cumulative quantity]
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@ILANGO_10 i hope this help you!
@ILANGO_10 i hope this help you!
Thank you so much sir... It means a lot..
Hi, @ILANGO_10
You can try the following methods. You need to add an index column to Power Query first.
Column:
Cumulative quantity =
CALCULATE ( SUM ( 'Table'[quantity] ),
FILTER ( 'Table' ,
[material] = EARLIER ( 'Table'[material] )
&& [Index] <= EARLIER ( 'Table'[Index] )
)
)
Result = [stock]-[Cumulative quantity]
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much sir...
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |