CODEWITHSUNDEEP
powerbidax
Chase Holt
Chase Holt

Reputation: 1

making all customer when any users has value

Date:

Customer Sales User Last Order Order Sent
1001 abc
1001 afe
1001 wr3
1002 avc 1/1/2021 Yes
1002 abc
1003 abc 1/1/2021 Yes

I have the table above and I need a "Dax formula" that will label the Sales as yes for all users for each customer if the last order has a date value in it. or order sent is Yes, I'm open to either.

When I can make a filter that would show if that one line has an order but I need help making the entire customer for sales if they have placed an order.

Upvotes: 0

Views: 29

Answers (1)

Strictly Funk
Strictly Funk

Reputation: 358

If this is the desired result, you can calculate Sales using a measure like this:

Sales = CALCULATE(
    MAX(Customers[Order Sent]),
    ALLEXCEPT(Customers,Customers[Customer]))

This video is a good example of how to calculate the max within a group using a measure.

Upvotes: 0

Related Questions