cancel
Showing results for
Did you mean:
MarcoG2000 Frequent Visitor

synthetic result for each customer on each day

Hi, I have a simple table with three columns.

Each line is an event that concerns a customer in a day. For each customer, multiple events can occur in one day with the same or different results.

he problem is this: Create a new table that has to be assigned only one synthetic result for each customer on each day. The synthetic result must have this order of priority. If there is an A or B then "Very Good", if there is no A or B, but there exists C or D then "Good", otherwise "Bud". I enclose the excerpt of the initial table and the desired one.

Thank you very much for helping.  1 ACCEPTED SOLUTION

Accepted Solutions Community Support Team

Re: synthetic result for each customer on each day

Hi @MarcoG2000,

You could create a calculated table with the formula below to get your expected output.

```Table 2 =
SUMMARIZE (
'Table',
'Table'[Date],
'Table'[IDCustomer],
"out_come", IF (
OR ( MIN ( 'Table'[OUTCOME] ) = "A", MIN ( 'Table'[OUTCOME] ) = "B" ),
"Very Good",
IF (
OR ( MIN ( 'Table'[OUTCOME] ) = "C", MIN ( 'Table'[OUTCOME] ) = "D" ),
"Good",
"Bud"
)
)
)
```

Then you will get the output below. Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Community Support Team

Re: synthetic result for each customer on each day

Hi @MarcoG2000,

You could create a calculated table with the formula below to get your expected output.

```Table 2 =
SUMMARIZE (
'Table',
'Table'[Date],
'Table'[IDCustomer],
"out_come", IF (
OR ( MIN ( 'Table'[OUTCOME] ) = "A", MIN ( 'Table'[OUTCOME] ) = "B" ),
"Very Good",
IF (
OR ( MIN ( 'Table'[OUTCOME] ) = "C", MIN ( 'Table'[OUTCOME] ) = "D" ),
"Good",
"Bud"
)
)
)
```

Then you will get the output below. Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.