How would you show sales by ship date when the model normally filters by order date?

Instruction: The expression assumes both date relationships already exist and compatible date keys are used. Replace Sales[Amount] with the agreed revenue definition. The nested calculation applies the nonblank filter after switching the date relationship and preserves existing ship-date filters. Validate the expression in your actual model.

Context: Chooses the relationship design from reporting requirements and tests cross-month orders plus unshipped records, including totals.

Updated

Official answer available

Read the opening below, then unlock the full answer and practical guidance.

I'd first confirm whether users need one date slicer that changes a measure's meaning or independent order-date and ship-date filters. For one slicer, I'd keep the Date-to-OrderDate relationship active and create an inactive Date-to-ShipDate relationship...

Upgrade to view official answer

Related Questions