synthetic result for each customer on each day

[MarcoG2000]

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.

[v-piga-msft · Accepted solution]

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