Plan vs Fulfilment using FIFO

• Planner breakdown the forecast volume to weekly requirements (Daily Go Rate) in chronological order.

• When WOs are generated based RoP, the order quantities may be > production capacity. WOs are prioritized and allocated using the combination of part numbers x quantities at the time the DGR is planned.

• The WO quantities may not align with DGR quantities.

Subject | Subject

Some text here about the topic of discussion

Solve the problem in DAX

Data transformation and data preparation

• Merge Plan and Fulfilment records using Power Query

• Multiple columns are used to order the records

• Add record index

Subject | Subject

Some text here about the topic of discussion

Solve the problem in DAX

Calculated columns to keep track of two sets of running totals

• ​Cumulative totals and previous total for each type = buy / PLAN

• Cumulative totals and previous total for each type = sale / WO

Subject | Subject

Some text here about the topic of discussion

FILTER(<table>,<filter>)

Some text here about the topic of discussion

Returns a table that represents a subset of another table or expression.

SUMX(<table>, <expression>)

Some text here about the topic of discussion

Returns the sum of an expression evaluated for each row in a table.

Previous

Cumulative

Subject | Subject

Some text here about the topic of discussion

Solve the problem in DAX

Some text here about the topic of discussion

Final calculation makes use of the four running total columns to help detect which “buy” / "PLAN" row should be considered for any given “Sale” / "WO.

ADDCOLUMNS(<table>, <name>, <expression>[, <name>, <expression>]…)

Some text here about the topic of discussion

Adds calculated columns to the given table or table expression.