Learn DAX with an example

Learn DAX with an example

By Li Da Gan

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

Multiple Choice

___ is Plan and ___ is Fulfilment

• DGR & WO

• Demand & Supply

• Sale & Buy

• Sales & Inventory

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

Open Ended

Create VAR RunningTotal keep track of the running totals of [sales] in 'Table1', with filter [product] = "x"

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.

Multiple Choice

Arrange the tasks in the correct order

1. Calculated columns to keep track of two sets of running totals

2. Merge Plan and Fulfilment records using Power Query

3. Final calculation makes use of the four running total columns

4. Add record index

5. Multiple columns are used to order the records

• 2, 4, 5, 1, 3

• 2, 5, 4, 1, 3

• 3, 1, 4, 5, 2

• 2, 5, 4, 3, 1

Open Ended

what are the potential business problems that you can apply similiar solution?