Rolling Stock DAX Measure

delmayhan — Fri, 13 Oct 2023 11:53:08 GMT

Hi Guys,

I want to create a rolling stock measure in Powerbi from a base value that is a field. So till now what i created is this measure :

Planned Stock =
CALCULATE (
( [Planned Delivery Quantity (Base Unit)] -[Required Quantity (Base Unit)] ) ,
FILTER (
ALL ( 'Date'[Date] ),
'Date'[Date] <= MAX ( ( 'Date'[Date] ) )
)
) Planned Stock this works fine.

Only what i want to do is that it take a starting stock from this field sum('inventory[QuantityUnrestricted] ') then it does the same as the measure in the planned stock. I tried but it didnt succeed. This is the measure:

RollingStockWithStartValue =

VAR __startValue = SUM('Inventory'[QuantityUnrestricted])

VAR __currentRow = MIN('Date'[Date])

RETURN

IF(

ISBLANK(__currentRow),

BLANK(),

__startValue +

CALCULATE(

[Planned Delivery Quantity (Base Unit)] - [Required Quantity (Base Unit)],

FILTER(

ALL('Date'),

'Date'[Date] <= __currentRow

)

and this is the output

i wanted it to be on the 10/10/2023 1480-256,16 and from that point will that be the value till there is other requirement or delivery

Re: Rolling Stock DAX Measure

Anonymous — Mon, 16 Oct 2023 08:05:46 GMT

Hi delmayhan ,

I think you can try code as below to create a new measure based on original [RollingStockWithStartValue] measure.

NEWRollingStockWithStartValue = SUMX ( FILTER ( ALL ( Date ), 'Date'[Date] <= MAX ( 'Date'[Date] ) ), [RollingStockWithStartValue] )

If this reply still couldn't help you solve your issue, please share a sample file with us.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Rolling Stock DAX Measure in DAX Commands and Tips

Rolling Stock DAX Measure

Re: Rolling Stock DAX Measure