DAX calculation

Question

enter image description hereWhat DAX calculation to calculate the Sales $ Fulfilled where Is Originating Online Sales Store = "Y" and match the Fulfilling Location to Originating Location Meaning, any sales that were fulfilled through the Store, but originated online. In the attached image, the New Measure should be the expectation.

• Michal: Depends. What is your schema, is it one table or do you have a proper star schema. Do you want a measure or a calculated column.

Answer 1

you can try this

Column =
IF (
 'Table'[Is Originating Online Sales Store] = "Y",
 BLANK (),
 MAXX (
 FILTER (
 'Table',
 'Table'[Date] = EARLIER ( 'Table'[Date] )
 && 'Table'[Location Name] = EARLIER ( 'Table'[Orinigating Location Name] )
 ),
 'Table'[Sales Fulfilled]
 )
)

enter image description here