DAX calculation

Question

What 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.

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. — Michal
– Michal, Commented Aug 16 at 22:47

Ryan · Accepted Answer · 2025-08-18 01:23:28Z

0

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]
    )
)

answered Aug 18 at 1:23

Ryan

2,6891 gold badge2 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DAX calculation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related