cover the qty in a table

[RosannaBALE]

hi everybady , i need your help

if i have data in 2 the table A e B

TABLE 1

ITEM	QTY
A	1
B	1
C	3

TABLE 2

ITEM	QTY
A	2	X
B	3	Y
C	5	Z

  i need to create the table 3 like below to cover the qty  of the first item of table 1 until it finished the qty of the item A of table 2

TABLE 3

ITEM	QTY
A	1	X
B	1	X
C	3	Y

[V-pazhen-msft]

@RosannaBALE 

Unfortunately, I am afraid it is not possible to get your expected table with Power BI. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

I believe:

TABLE 3 = 
  ADDCOLUMNS(
    'TABLE 1',
    "New",
      VAR __Qty = MINX(FILTER('TABLE 2', 'TABLE 2'[QTY] > EARLIER([QTY]),'TABLE 2'[QTY])
      RETURN MAXX(FILTER('TABLE 2', [QTY] = __Qty,[ unnamed column which is impossible ] )
  )