Return each requested result from Work while keeping Raw available as the staging query. The tasks combine table transformations with list and record values. Use the Advanced Editor to name intermediate results when a single long expression becomes difficult to inspect.
A result can be numerically plausible yet use the wrong population. Check filters before totals and keep null handling close to the operation that needs it. An extracted column list no longer carries its row identifiers, so use a table filter when the output needs records. All records and values here are fictional. The hidden replacement changes the numbers and the row count; the same M must still produce the requested output shape and values.