Creation and Warehouse (Measure Creation) for Week 1 is constant Week 2 and so on is dynamic.

[Marksquall]

Good Day,

I would like to request some help regarding 2 measures for creation and warehouse.

In excel:

"Creation" is basically Week 1 is equal to "Request" then Week 2 forward is [=IF(B5>C2, "0", C2-B5)] and so on.

"Warehouse" is Week 1 [=B3-B4] then Week 2 foreward is [=B5+C3-C4] and so on.

I would need the measure for both creation and warehouse when 1st week value is derive on a contant value then Week 2 forward it dynamically changes from last week value.

Here is a copy of the PBI file for reference.

https://drive.google.com/file/d/1iY4GElMdvyihPmpFsP0Y6JGWtqztNR9l/view?usp=share_link

Excel file:

https://docs.google.com/spreadsheets/d/1F2JLVcpESl4MWiBhClN7C1g99tlKzYQY/edit?usp=share_link&ouid=11...

[wdx223_Daniel]

it's hard to resolve this kind of recursion problem with DAX code, and suggest you to use M to created two columns.

= Table.FromRecords(List.Accumulate(Table.ToRecords(#"Changed Type"),{{},0},(x,y)=>let a=List.Max({y[Request],x{1}})-y[Shipped] in {x{0}&{y&[Creation=List.Max({0,y[Request]-x{1}}),Warehouse=a]},a}){0})